I need to create a formula to substitute a letter result for a range of
numerals. That is I want to represent a letter grade for a range of
percentage results. Any tips?
I need to create a formula to substitute a letter result for a range of
numerals. That is I want to represent a letter grade for a range of
percentage results. Any tips?
To convert scores to letter grades use a Lookup table and VLOOKUP functions.
OR a Lookup formula without a table
Assuming scores are in column A starting at A1.
In B1 enter this formula then drag/copy down column B
=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D","C-","C","C+","B","B+","A"})
Example only. Adapt for your scores and grades.
Note the curly braces internally.
Gord Dibben MS Excel MVP
On Sun, 23 Apr 2006 16:09:01 -0700, CdnMichael
<[email protected]> wrote:
>I need to create a formula to substitute a letter result for a range of
>numerals. That is I want to represent a letter grade for a range of
>percentage results. Any tips?
Gord Dibben MS Excel MVP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks