Lookup function

  • Thread starter Thread starter marvin
  • Start date Start date
M

marvin

I have excel 2003. I did a vlookup for my transcripts page. In the first
vlookup i needed it to look for the letter grade and give me the gradepoint
average. Now in the other cell i need it to look for the grade. In the cell
that gives the gradepoint average it has a formula in their already. Can i
still do a vlookup if the cell that has the information has a formula in it
already. Example. The cell that has the formula adds all the grades from
each class and gives me an accumluated gradepoint average for the ten classes
taken. Now that gradepoint average I want a letter for it. How would i do
this or can it be done.
 
Hi Marvin,

I have a worksheet that I believe is an example of what you want to do.
Would require some adaptation to suit your final needs.

You enter the letter grades for each student and it provides a GPA and an
average letter grade.

So if a student has the following letter grades, F, A, B, C, A, D, returns a
GPA of 2.33 and average letter grade of B-. The scales are adjustable to
suit your requirements.

contact me (e-mail address removed)

Regards,
Howard
 
Back
Top