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

Thank you for you help.

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.

=IF(A1< 90, "D", IF(A1< 95, "C", IF(A1 < 98, "B", "A")))

Where your score is in A1...
--
HTH...

Jim Thomlinson


"dchristo" wrote:

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

Thank you for you help.

=LOOKUP(A20,{0,90,95,98},{"D","C","B","A"})

--
__________________________________
HTH

Bob

"dchristo" wrote in message
...
I need a formula for
if 100 - 98 = A
97 - 95 = B
94 - 90 = C
90 = D

Thank you for you help.

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.

=LOOKUP(A1,{0,90,95,98;"D","C","B","A"})

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"dchristo" wrote in message
...
I need a formula for
if 100 - 98 = A
97 - 95 = B
94 - 90 = C
90 = D

Thank you for you help.

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.

One other way, arrange your table as follow in a far away location
and hide it if you want on the spreadsheet and use this formula

=IF(ISNA(VLOOKUP(C2,A2:B5,2,1)),"D",VLOOKUP(C2,A2: B5,2,1))

Grade score
89 D
90 C
95 B
98 A

Change the references according to yours
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"dchristo" wrote:

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

Thank you for you help.