Set up a table in cells a1:b4 like the following
0 F
50 C
60 B
75 A
Name this range "Scores"
In cell D3 enter the test score - as an integer rather than as a percentage.
In cell E3 enter the following formula =VLOOKUP(D3,Scores,2)
Regards
Phil Smith
"whassup" wrote:
supposing im keying in test scores for a test where the full score is
100.
75 marks and over gets a A grade
60 to 74 marks gets a B grade
50 to 59 marks a C grade
49 and below a F grade
what is the formula that i use so that i can key in any random score
from 0 to 100 in one column and the corresponding grade would appear in
another column?
thanks
--
whassup
------------------------------------------------------------------------
whassup's Profile: http://www.excelforum.com/member.php...o&userid=21553
View this thread: http://www.excelforum.com/showthread...hreadid=488435