Help with nesting

[cdsaroma]

Is there anyway to nest this into one formula?

these are the (3) formulas:

=IF(A2<1994,"No PW","")
=IF(A2>=1994,"Card","")
=IF(AF="lux","Cert","")

thanks

 

[Joe4]

In your third condition, is that supposed to "A2" also, and not "AF"?
If so, then just nest your if statements,:

=IF(A2<1994,"No PW",IF(A2>=1994,"Card",IF(A2="lux","Cert","")))

 

[markf5998]

The first two can be combined as

=IF(A2<1994,"No PW","Card")

But check your 3rd statement...looks like a typo. should "AF" be something else?

 

[cdsaroma]

Thanks...
It is AF, is that possible?

 

[Joe4]

What is "AF"?
Are you trying to see if "lux" exists anywhere in column AF on your sheet (instead of in a particular cell like "AF2")?

 

[cdsaroma]

Stupid me...it was meant to be AF2, I have it working now.

thanks a heap

 

[Joe4]

Stupid me...it was meant to be AF2, I have it working now.

Note the hierarchy of nested IF statements. It stops once it finds the first True statement. So how you order them is imporant.

For example, what do you want to return if A2 < 1994 AND AF2 ="lux"?
Do you want to return "No PW" or "Cert"?
Whichever one "wins" in that instance is the condition you want to place first in your nested IF statement.

 

[cdsaroma]

Note the hierarchy of nested IF statements. It stops once it finds the first True statement. So how you order them is imporant.

For example, what do you want to return if A2 < 1994 AND AF2 ="lux"?
Do you want to return "No PW" or "Cert"?
Whichever one "wins" in that instance is the condition you want to place first in your nested IF statement.

I didn't know that, thanks.