Thread: Grading Scores
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Grading Scores

=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.