assigning a letter to a number range

dardeau2 · Apr 25th, 2002, 01:45 PM

I am using Excel as a gradebook and would like to assign letter grades to a number range (100-89.5 = A, etc.). Could you help me with the formula or function?

Mark W. · Apr 25th, 2002, 01:47 PM

=VLOOKUP(A1,{0,"F";...;89.5,"A"},2)

What's are the other grade demarcations?

Are they...

=VLOOKUP(A1,{0,"F";59.5,"D";69.5,"C";79.5,"B";89.5,"A"},2)

[ This Message was edited by: Mark W. on 2002-04-25 12:53 ]

Aladin Akyurek · Apr 25th, 2002, 01:55 PM

Quote:

On 2002-04-25 12:45, dardeau2 wrote:
I am using Excel as a gradebook and would like to assign letter grades to a number range (100-89.5 = A, etc.). Could you help me with the formula or function?

What is etc, I mean the rest?

You can make a 2-column list with number grades (expressed as intervals) in the first column and corresponding letter grades in the second column. Give a name to the range of this 2-column list, e.g., LGRADES, via the Name Box. And, use:

=VLOOKUP(E1,LGRADES,2)

where E1 houses a number grade.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 01:45 PM	#1
dardeau2 New Member Join Date: Apr 2002 Posts: 1	I am using Excel as a gradebook and would like to assign letter grades to a number range (100-89.5 = A, etc.). Could you help me with the formula or function?

Apr 25th, 2002, 01:47 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=VLOOKUP(A1,{0,"F";...;89.5,"A"},2) What's are the other grade demarcations? Are they... =VLOOKUP(A1,{0,"F";59.5,"D";69.5,"C";79.5,"B";89.5,"A"},2) [ This Message was edited by: Mark W. on 2002-04-25 12:53 ]