Community archive

Ask something
Discussion Locked

Help in excel

0 helpful
1 reply

by midge1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
as a marker in a school, i want to know how to use marking grades to represent a range of values in excel. the spreadsheet contains the values from 0-100%. however, i want the values to show a range of marks. e.g. A* = 90-100%. i am using office XP.will some vb programming do?

1 reply

by dklippert

Use a lookup table.

On the data worksheet,(or on a different sheet) make a table.

In the left column enter 0,40,60 etc.(the break points for the grades).

In the right column enter the letter grade E,D-,D etc.

Select the table and go to Insert>Name Define. Call the table LetterGrade.

Next, enter this formula:

=VLOOKUP(A2,LetterGrade,2,TRUE)

Excel will look at the value in A2 and compare it to the entries in the first column of the LetterGrade table. It will then display the value in column 2, the letter grade.

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.

This discussion is closed to new replies.