Teh Hiv-or needs Excel help! :? Or I Can Haz Amber Zone Pls?

[Gruffty]

I want to make Excel automatically show Amber zones in Hiver space. I can already get it to show Red zones (A1 = Starport code, AA1 = Non-Hiver TC - Nh) using:

=IF(AND(A1="X",AA1="Nh "),"R","")

which works fine.

However, according to AM7 Hivers p. 35, worlds with Non-Hiver populations and TL of 6 or less are classified as the equivalent of Amber zones. This works (A8 = TL, AA1 = Non-Hiver TC - Nh):

=IF(AND(A8<=6,AA1="Nh "),"A","")

But how do I put these two formulae together into one cell so that both still work?

 

[MacTrom]

I haven't worked in Excel for some time, but you might try something like this:
=IF(AND(A1="X",AA1="Nh "),"R",IF(AND(A8<=6,AA1="Nh "),"A",""))

Hth
MacTrom

 

[Gruffty]

Thanks, that worked!