Nested if with an unwanted false result
 

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),$E1 0,""))

Regards
Pelham

Nested if with an unwanted false result
 

Try this:

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



--
Biff
Microsoft Excel MVP


wrote in message
...
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),$E1 0,""))

Regards
Pelham