Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.