Nested If Statement

[tkeiffer]

Hello,
Is there a way to combine these in one cell? I want to return the word "Orange", or "Red" or "No Risk". Is that possible? I've tried a bunch of different ways and I can't seem to make it work

=IF(AND(H3 = "Y"),AND(E3<15, E3>0)) = "Orange"
=IF(AND(H3 = "Y"),(E3=0)) = Red
Else "No Risk"

 

[Ken Cowen]

This is your logic, combined into one formula. Not sure if it makes sense, but I hope it helps.

=IF(AND(H3="Y",E3<15,E3>0),"Orange",IF(AND(H3="Y",E3=0),"Red","No Risk"))

Ken

 

[Jonmo1]

Try

=IF(H3="Y",LOOKUP(E3,{0,1,15},{"Red","Orange","No Risk"}),"No Risk")

 

[mrmmickle1]

Try this:

=IF(AND(H3="Y",E3<15,E3>0),"Orange",IF(AND(H3="Y",E3=0),"Red","No Risk"))

 

[BrianJN1]

Try this:
=IF(AND(H3="Y",E3<15,E3>0),"Orange",IF(AND(H3="Y",E3=0),"red","No Risk"))

It effectively reads as - if "this", or "this" else "this".