Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EZ Q 4 U: How do I change a number to text, based on the number
Hi,
I am a TA for a large course. I have the score results for a midterm. The professors has assigned grade cutoffs (e.g. 53-56 correct = A-, and so on). I am not going to type in all the grades for some 300 students. What formula would I use to change a number value to a grade? THANK YOU!! LaTonya |
#2
|
|||
|
|||
Hi!
Adapt this this conversion table to meet your needs: <41 F 41-44 D 45-48 C 49-52 B 52 A Assume student name is in A1 and number grade is in B1. Now, with that table in mind use a formula like this: =LOOKUP(B1,{0,"F";41,"D";45,"C";49,"B";53,"A"}) Biff -----Original Message----- Hi, I am a TA for a large course. I have the score results for a midterm. The professors has assigned grade cutoffs (e.g. 53-56 correct = A-, and so on). I am not going to type in all the grades for some 300 students. What formula would I use to change a number value to a grade? THANK YOU!! LaTonya . |
#3
|
|||
|
|||
Thanks Biff.
Related Q for Biff (or anyone) does this function itself take care of ranges (e.g. 40-50 = A or do I have to include the range in the function itself? "Biff" wrote: Hi! Adapt this this conversion table to meet your needs: <41 F 41-44 D 45-48 C 49-52 B 52 A Assume student name is in A1 and number grade is in B1. Now, with that table in mind use a formula like this: =LOOKUP(B1,{0,"F";41,"D";45,"C";49,"B";53,"A"}) Biff -----Original Message----- Hi, I am a TA for a large course. I have the score results for a midterm. The professors has assigned grade cutoffs (e.g. 53-56 correct = A-, and so on). I am not going to type in all the grades for some 300 students. What formula would I use to change a number value to a grade? THANK YOU!! LaTonya . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
What defines number or text | New Users to Excel | |||
returning a text cell based on a number cell | Excel Worksheet Functions |