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"
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"