# Revision history [back]

If I understand correctly you wish

0-80 = "A"
80-95 = "B"
>95 = "C"


Less than 0=undefined. The value of 80 is ambiguous.

Try this formula

=IF(A1>95,"C",IF(AND(A1<=95,80<A1),"B","A"))


Adjust the logic around 80 to give the result you want.