Tuesday, April 15, 2008

Grades in Excel

Yes, I am using Excel. It does a reasonably good job at tallying grades and summing things up, it is a spreadsheet after all. However, I have had trouble issuing "letter grades" using Excel. In the past I have come across ways to accomplish like this: Write a series of "IF" statements embedded in each other.

=IF(A1>90,A,IF(A1>80,B,IF(....
Wow. How Ugly and a really ugly function if I got it wrong. I guess I was looking in the wrong place. Should have left out the "letter" when I was searching the interblog. The pretty way to do this is vlookup. Found through, who would have guessed, the Microsoft site.
=vlookup(A1,B1:C10,TRUE)
With the number grades in column B and the Letter Grades in C. No more worrying about writing that horrific "IF" statement, which reminds me of using "goto".

1 comment:

Anonymous said...

Let me know if you plan on doing more stuff with Excel.. :) Been using Vlookup for ages :P