Nested if with an unwanted false result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pelham.higgins@jrep.co.jp - 19 Mar 2008 05:08 GMT

Dear All

I have the following formula that works fine:

=IF(ISBLANK($F10),"",IF(MONTH($F10)=MONTH(K$6),IF(YEAR($F10)=YEAR(K$6),
$E10,"")))

However, at the appropriate times when the IF formula is genuinely
false it is responding with "FALSE" in the cell. How can I have it so
that nothing appears in the cell if it is false?

FYI, the following formula (which the above formala is based on) works
fine:

=IF(ISBLANK($F10),"",IF(MONTH($F10)=MONTH(M$6),$E10,""))

Regards
Pelham

Reply to this Message

T. Valko - 19 Mar 2008 05:31 GMT

Try this:

=IF($F10="","",IF(AND(MONTH($F10)=MONTH(K$6),YEAR($F10)=YEAR(K$6)),$E10,""))

Signature

Biff
Microsoft Excel MVP

> Dear All
>
[quoted text clipped - 14 lines]
> Regards
> Pelham

Reply to this Message