Thread: Grading Scores
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Grading Scores

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