Grading Scores
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
"dchristo" wrote:
I need a formula for
if 100 - 98 = A
97 - 95 = B
94 - 90 = C
90 = D
Thank you for you help.
|