Is this POSSIBLE IN EXCEL ?

[donfettuccini]

Hello!

I have a list of 100 names and test scores, then a range of letter
grades.

Name Scores
Joe 100
Billy 95
Max 65
John 49

Grades from100-95, will get a letter Grade A
Grades from 94-80, will get a letter Grade B
79-65, will get a letter Grade C
64-50, will get a letter Grade D
49-0, will get a letter Grade F

I wanted to know if there is a combination of function that will allow
me to convert the scores to their corresponding letter grade. Possible
without macros.


Thanks

 

[Paul B]

donfettuccini, have a look at Create a VLookup formula for a range of values
here

http://www.contextures.com/xlFunctions02.html#Range


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"donfettuccini" <[email protected]>
wrote in message
news:[email protected]...

 

[CLR]

Assuming your names are in column A and your scores are in column B in C1
put GRADES
in G1 put 0
in G2 put 50
in G3 put 65
in G4 put 80
in G5 put 95

and
in H1 put F
in H2 put D
in H3 put C
in H4 put B
in H5 put A

finally in C2 put this formula and copy down..........
=VLOOKUP(B2,$G$1:$H$5,2,TRUE)

Vaya con Dios,
Chuck, CABGx3




"donfettuccini" <[email protected]>
wrote in message
news:[email protected]...

 

[donfettuccini]

Thanks a lot for the feedback,
I got the formula to work.

Thanks a lot Paul B and CLR.

 

[Shaz]

If you do not want to use a table, you may use the following array
function:

The numbers in the rightmost brackets are the numerical codes
equivalent to letter grades.

=CHAR(SUM(--(A2>{0,48,64,79,94})*--(A2<{50,65,80,95,101})*{70,68,67,66,65}))

Where A2 has the number grade.
enter the formula and press contrl + shift + enter.

 

[Shaz]

=CHAR(SUM(--(F28>{0,48,64,79,94})*--(F28<{50,65,80,95,101})*{70,68,67,66,65}))


as array formula.

 

[Dana DeLouis]

Just another variation...

=CHAR(65+(A2<95)+(A2<80)+(A2<65)+2*(A2<50))

HTH
--
Dana DeLouis
Win XP & Office 2003


"donfettuccini" <[email protected]>
wrote in message
news:[email protected]...