Hello. I am trying to get A,B,C,D to appear based on a different cells value

IF U7 is less than 5; then "A"

IF U7 is less greater than 5, but less than 20; "B"

IF U7 is greater than 20; then "C"

IF U7 is "N/A" (from a vlookup); "D"

This is what I have now and it works for the "C" but returns #Value for anything that should return "A" and False for anything that should return "B"

=IF(IF($U7<5,"A"),IF(AND($U7>5,$U7<20),"B"),IF($U7>20,"C"),IF($U7="N/A","D"))

IF U7 is less than 5; then "A"

IF U7 is less greater than 5, but less than 20; "B"

IF U7 is greater than 20; then "C"

IF U7 is "N/A" (from a vlookup); "D"

This is what I have now and it works for the "C" but returns #Value for anything that should return "A" and False for anything that should return "B"

=IF(IF($U7<5,"A"),IF(AND($U7>5,$U7<20),"B"),IF($U7>20,"C"),IF($U7="N/A","D"))

Last edited: