Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula advice
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula advice
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |