Prev: Conditional Formatting for one cell matching another with text
Next: lookup to multiple rows and columns
From: marvin on 14 Feb 2010 18:43
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.
From: L. Howard Kittle on 14 Feb 2010 19:03
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 lhkittle(a)comcast.net

Regards,
Howard

"marvin" <marvin(a)discussions.microsoft.com> wrote in message
news:C381BB23-D835-49CE-B21E-93E71C0AFC98(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: Conditional Formatting for one cell matching another with text
Next: lookup to multiple rows and columns