IF A= X, IF A=Y, If A<>X or Y, ???

[jencha]

Wondering how to format this...

=
IF(AS2="Y11Q4", "Established,
IF(AS2="Y12Q1", "New",
IF(OR(AS2<>"Y11Q4", AS2<>"Y12Q1"),
"Unestablished")

Basically, if AS2 doesn't equal Y11Q4 or Y12Q1, I would want to categorize this into a third Unestablished category...

Thanks, hope this isn't a silly question...

 

[Joe4]

Since you are doing NOT equal, I think you actually want AND instead of OR, i.e.

[COLOR=#333333]=[/COLOR][COLOR=#333333]IF(AS2="Y11Q4", "Established",[/COLOR][COLOR=#333333]IF(AS2="Y12Q1", "New",[/COLOR][COLOR=#333333]IF(AND(AS2<>"Y11Q4", AS2<>"Y12Q1"), [/COLOR][COLOR=#333333]"Unestablished","")))[/COLOR]

 

[Jonmo1]

You don't need to test if AS2 does not equal Y11Q4 and Y12Q1.
If both the first 2 if's are not TRUE, then it can be assumed.

IF(AS2="Y11Q4", "Established",IF(AS2="Y12Q1", "New","Unestablished"))

 

[Scott T]

Try

=IF(AS2="Y11Q4","Established",IF(AS2="Y12Q1","New","unestablished"))

You do not need to test if AS2 is not equal to the values because the formula will not get to that calculation point if it was equal one of the values.

 

[Marcílio_Lobão]

jencha, good afternoon.

Try to use:

=IF(AS2="Y11Q4", "Established,
IF(AS2="Y12Q1", "New",
IF(AND(AS2<>"Y11Q4", AS2<>"Y12Q1"),"Unestablished")))

I hope it helps

 

[Joe4]

Good catch JonMo and Scott. It is totally unnecessary to check them, do to the previous two conditions.
Was working too fast and completely overlooked that!

 

[jencha]

Thank you so much for your help!!

 

[Jonmo1]

You're welcome.

 

[jencha]

I have another question and I thank you in advance for taking a look. I want to say that If AY2:BB2 contain either New or Established (another way to think of it may be to exclude Unestablished), to state the value of G2. I've tried a variety of methods to no avail. You guys are really the best, I'm a brand new analyst on my second week of work

 

[Scott T]

Try. change the true and false values to what you want

=IF(OR(ISNUMBER(MATCH("New",AY2:BB2,0)),ISNUMBER(MATCH("Established",AY2:BB2,0))),"value if true","value if false")