Nested if with an unwanted false result

[pelham.higgins]

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

 

[T. Valko]

Try this:

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