Grading Scores

[dchristo]

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

90 = D

Thank you for you help.

 

[Jacob Skaria]

Try the below

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

If this post helps click Yes

 

[Jim Thomlinson]

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

Where your score is in A1...

 

[Bob Phillips]

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

 

[dchristo]

Everything is coming back as a "D"

Try the below

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

If this post helps click Yes

 

[RagDyeR]

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

--

HTH,

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

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

90 = D

Thank you for you help.

 

[Jacob Skaria]

Paste the formula as such in cell B1
=IF(AND(A1>0,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

 

[Francis]

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