Paste the formula as such in cell B1
=IF(AND(A10,A1<=100),LOOKUP(A1+0,{0,90,95,98},{"D ","C","B","A"}),"")

and enter values in A1 and see....This works only if value is between 1 and
100 (both inclusive)

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


"dchristo" wrote:

Everything is coming back as a "D"

"Jacob Skaria" wrote:

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.