Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula gives unwanted result | Excel Worksheet Functions | |||
Unwanted result | Excel Discussion (Misc queries) | |||
Result = to 0 says false | Excel Worksheet Functions | |||
false result | Excel Worksheet Functions | |||
Unwanted LOOKUP() Result | Excel Discussion (Misc queries) |