Grading Scores

  • Thread starter Thread starter dchristo
  • Start date Start date
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
 
=IF(A1< 90, "D", IF(A1< 95, "C", IF(A1 < 98, "B", "A")))

Where your score is in A1...
 
Everything is coming back as a "D"

Jacob Skaria said:
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
Click to expand...
 
=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
Click to expand...

Thank you for you help.
 
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
 
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
 
Back
Top