I'm currently working on a basic evaluation survey on excel. I've set it up so that one can input letter grades for each aspect of the survey. The letter grades are converted into numbers, and added up to form a total score. My question is, how do I make the sheet output a letter to the user, that is determined by the total score? (ie. 90 and above is an A, 80 and above is a B, etc.) Any assistance would be appreciated.
Something like this:
=LOOKUP(A1,{0,40,60,80,90},{"E","D","C","B","A"})
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
What about if I want a range of values to display one letter? ie. from 40 to 60 is an "E" ranking.
The numbers in the first array of values are the lower limit of each range. Based on the formula given, the ranges are
0-39 returns E
40-59 returns D
60-79 returns C
80-89 returns B
90+ returns A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks