Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Q: Excel function
Hello,
Grade Letter 100-96 A 95-90 A- 89-87 B+ 86-82 B 81-80 B- 79-77 C+ 76-72 C 71-70 C- 69-67 D+ 66-62 D 61-60 D- 59 or < F A column keeps Grade, wow can I get Excel figure out Letter in B column? Thanks, Jim. |
#2
|
|||
|
|||
Have a look in HELP index for VLOOKUP
-- Don Guillett SalesAid Software "JIM.H." wrote in message ... Hello, Grade Letter 100-96 A 95-90 A- 89-87 B+ 86-82 B 81-80 B- 79-77 C+ 76-72 C 71-70 C- 69-67 D+ 66-62 D 61-60 D- 59 or < F A column keeps Grade, wow can I get Excel figure out Letter in B column? Thanks, Jim. |
#3
|
|||
|
|||
Let's imagine that the number grades are in column A and you want the letter
grades to go to column B, and all data start from Row 2. Make your grading scale in two empty columns (e.g., C and D), IN ASCENDING ORDER, as follows: C D Grade (cutoff) Letter 0 F 60 D- 62 D 67 D+ 70 C- 72 C 77 C+ 80 B- 82 B 87 B+ 90 A- 96 A In B2, enter the formula, =VLOOKUP(A2,$C$2:$D$13,2,-1), and fill-in the formula down to the last row. Note: Make sure that the grades in Col A are rounded off to whole numbers, to avoid a scenario such as 95.9999 translating into A- (instead of A)! Regards. B.R.Ramachandran "JIM.H." wrote: Hello, Grade Letter 100-96 A 95-90 A- 89-87 B+ 86-82 B 81-80 B- 79-77 C+ 76-72 C 71-70 C- 69-67 D+ 66-62 D 61-60 D- 59 or < F A column keeps Grade, wow can I get Excel figure out Letter in B column? Thanks, Jim. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Is there a Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
Return value with using Excel function | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |