Forum Discussion
Multiple IF's
I've spent hours trying to fix this problem. I'm trying to run the formula below but excel keeps giving me an error. It looks so straight forward at face value.
=IF(ISBLANK(N44), "", IF(N44>0), "Win", IF(N44<0), "Loss").
If N44 is blank, leave output cell blank. If N44>0, output cell reads "Win". If N44<0, output cell reads "Loss".
N44 itself contains a forumla =IF(ISBLANK(K44),"",M44/K44).
Please help. So frustrated.
The issue with your formula is that the parentheses are not correctly placed.
The correct formula should be:
=IF(ISBLANK(N44), "", IF(N44>0, "Win", IF(N44<0, "Loss")))
This formula checks if cell N44 is blank.
If it is, the output cell will be left blank.
If N44 is not blank and its value is greater than 0, the output cell will read “Win”.
If N44 is not blank and its value is less than 0, the output cell will read “Loss”.
I hope this helps!
2 Replies
The issue with your formula is that the parentheses are not correctly placed.
The correct formula should be:
=IF(ISBLANK(N44), "", IF(N44>0, "Win", IF(N44<0, "Loss")))
This formula checks if cell N44 is blank.
If it is, the output cell will be left blank.
If N44 is not blank and its value is greater than 0, the output cell will read “Win”.
If N44 is not blank and its value is less than 0, the output cell will read “Loss”.
I hope this helps!
=IF(LEN(N44)=0, "", IF(N44>0, "Win", IF(N44<0, "Loss")))You can try this formula which returns the intended result in my sheet.
