Forum Discussion

Mitch_0409's avatar
Mitch_0409
Copper Contributor
Apr 13, 2023
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), "...
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Apr 13, 2023

    Mitch_0409 

    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! 

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 13, 2023

Mitch_0409 

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! 

Resources