| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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) | |||
Linear Mode
