Forum Discussion

Copper Contributor

Apr 09, 2024

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...

Formulas and Functions

CaliMayhem

Copper Contributor

Apr 09, 2024

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....

SergeiBaklan

MVP

Apr 09, 2024

CaliMayhem

As variant

=SWITCH(
  TRUE,
  OR( C6 = {"Yes","Not applicable"} ), "Explanation not required",
 "")