Thread
:
Grading Scores
View Single Post
#
3
Posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
Posts: 5,939
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.
Reply With Quote
Jim Thomlinson
View Public Profile
Find all posts by Jim Thomlinson