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. |
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. |
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. |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com