Forum Discussion
Solved
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), "...
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.