If formula help needed

[marquiese]

I am trying to build a formula that will help with the following problem:


If A and B is Yes , then C = Mission Critical
If A is Yes and B is No, then C = Critical Impact Replacement
If A is No and B is Yes, then C = Scarce Non-Critical
If A is No and B is No, then C = Mass Market
I need to get this into one formulated cell. I have been struggling for several hours. I would love any advice. I have tried If and, If or, but I can only get the first problem solved, the rest error out.

 

[dreid1011]

Give this a try:

=IF(AND(A2="Yes",B2="Yes"),"Mission Critical",IF(AND(A2="Yes",B2="No"),"Critical Impact Replacement",IF(AND(A2="No",B2="Yes"),"Scarce Non-Critical","Mass Market")))

 

[marquiese]

Give this a try:

=IF(AND(A2="Yes",B2="Yes"),"Mission Critical",IF(AND(A2="Yes",B2="No"),"Critical Impact Replacement",IF(AND(A2="No",B2="Yes"),"Scarce Non-Critical","Mass Market")))

You are amazing!! Huge Help!!

 

[dreid1011]

You're welcome, and happy to help.

 

[Cubist]

An alternative to avoid nested IFS.

=SWITCH(A2&B2,"YesYes","Mission Critical",  "YesNo","Critical Impact Replacement", "NoYes","Scarce Non-Critical","NoNo","Mass Market")

 

[MountainFog]

An alternative to avoid hard coding values:

=+INDEX($F$2:$H$4,XMATCH($A2,$F$2:$F$4),XMATCH($B2,$F$2:$H$2))