Try the below

=IF(AND(A10,A1<=100),LOOKUP(A1+0,{0,90,95,98},{"D ","C","B","A"}),"")

If this post helps click Yes
---------------
Jacob Skaria


"dchristo" wrote:

I need a formula for
if 100 - 98 = A
97 - 95 = B
94 - 90 = C
90 = D

Thank you for you help.