Forum Discussion
FALSE Responses When using IF Equations
Hi, I have an IF equation with a Yes/No Response [=IF(C3="Yes","Buy Cupcakes",IF(C3="No","Buy Brownies")). This works fine. What I am now trying to do is have an explanation in the next column, k...
If you omit the false argument, Excel will default to showing FALSE:
To show a blank instead, you could use:
=IF(C3="Yes","Yum","")
- That wors perfectly when I have two conditions. What do I do when I have three conditions and it only needs to be blank for one of them. This is what I tried, but it didn't work 😞
=IF(C6="Yes","Explanation not required",IF(C6="Not Applicable","Explanation not required,"IF(C6="No","")))
I am trying to use an excel spreadsheet that will heavily automate a task for us hence all the questions....As variant
=SWITCH( TRUE, OR( C6 = {"Yes","Not applicable"} ), "Explanation not required", "")You can arrange it as an IF-OR:
=IF(OR(C6="Yes","Explanation not required",C6="Not applicable"),"Explanation not required","")
