View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] pelham.higgins@jrep.co.jp is offline
external usenet poster
 
Posts: 1
Default 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