Thanks:  0
Likes:  0

# Thread: assigning a letter to a number range

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?

2. =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 ]

3. 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:

where E1 houses a number grade.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•