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

One way with the score in A1

=VLOOKUP(A1,{0,"F";50,"C";60,"B";75,"A"},2)

--
Regards,

Peo Sjoblom

(No private emails please)


"whassup" wrote in
message ...

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

For a score in cell A1, try this:
A2: =VLOOKUP(A1,{0,"F";50,"C";60,"B";75,"A"},2,1)
Note the curly braces, commas and semicolons.

Does that help?

***********
Regards,
Ron


"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

Hi!

One way:

A1 = score

=IF(A1="","",LOOKUP(A1,{0,"F";50,"C";60,"D";75,"A" }))

Biff

"whassup" wrote in
message ...

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

Oops!

=IF(A1="","",LOOKUP(A1,{0,"F";50,"C";60,"D";75,"A" }))

Replace the "D" with a "B".

Biff

"Biff" wrote in message
...
Hi!

One way:

A1 = score

=IF(A1="","",LOOKUP(A1,{0,"F";50,"C";60,"D";75,"A" }))

Biff

"whassup" wrote in
message ...

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

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