IF Function

[RJB78]

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

 

[CyrusTheVirus]

Try this:

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

 

[RJB78]

That works except the last part, "C" appeared instead of "D"

 

[CyrusTheVirus]

what do you have in U7?

Also, please note that you don't have criteria stating what you want if something is exactly 5 or 20, you only have greater than or less than, not greater than or equal to or less than or equal too. If you want to include 5 and 20, try the below.

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

 

[RJB78]

U7 is a vlookup to a number, the letter is based off the number, but for some lookups there aren't any numbers so it returns N/A, I want it to return D

 

[CyrusTheVirus]

Does the below formula not work for you? It should.

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