View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use a VLookup formula to return a letter grade, based on a
number. There are instructions for VLookup in Excel's Help, and there's
an example using letter grades he

http://www.contextures.com/xlFunctions02.html#Range

capecrusader wrote:
I am trying to make a spreadsheet to keep track of my grades. I am to the
point that I have a numerical grade, but I want to add another cell to keep
track of the letter grade. I want the alpha grade to update automaticly when
I update the numerical grade.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html