Forum Discussion
Solved
Excel if functions with condition 1, condition 2, condition 3, and condition blank
Hi there. This is my first time to post here. I have limited Excel knowledge. I know how to use an IF formula to do something like "if cell D2 = X, then do this; otherwise do something else." ...
- You have typed space in this formula IF(D2=" "," ","none of the above"), remove that space, try- =IF(D2="","","none of the above")
NathanB2 You need nested IF() functions.
=IF(D2="X","X Blah",IF(D2="Y","Y Blah",IF(D2="","","Something Else")))
Thank you very much for your help. Except for the blank bit, it worked for me. This is what I typed into Excel:
=IF(D2="a","a hi",IF(D2="b","b hi",IF(D2=" "," ","none of the above")))
Unfortunately, if d2 is blank, then it still says "none of the above." What I want in that case is for it to return nothing at all.
Do you have any suggestions for how to fix that?
