Cindy,

Give this a shot. You may have to change the values to meet your needs.

cil

=IF(A189,"A",IF(A179,"B", IF(A169,"C",IF(A159,"D","F"))))


"SeventFloorProfessor"
wrote in message ...
There's a way to do it using HLOOKUP, but you have to create a table that
assigns values (A+ is a 97 & a 4.0, for instance), so I don't know if you
want to do that. If you do, let me know, and I'll try to explain it.

=IF(E7<"",HLOOKUP(E7/100,GradeValue,2),"")

"Cindy" wrote:

I have this spreadsheet that merges onto a Transcript in Word..We have
Student Names, Class Dates, Grades for Classes per Terms, etc...They have
been manually figuring the GPA,,,,I set up some formulas that has helped,
but
need help on the more difficult ones..someone helped me last week with
the
following formula (finding and matching the Grade to return a GPA.
THANKS...Now I have been asked to find and match the Grade or GPA and
return
a Ltr Grade on the Transcript as well and I need help again...

The following formula matches the Grade to the GPA:

formula is: =SUMPRODUCT(--($AR$2:$AR$37=D3),$AS$2:$AS$37)

I tried using the same formula, just changing the Column numbers, but it
didn't work.Can you help me? I don't know if the problem is number to
text..(numeric to alpha)

lookup table sample is:

AR AS AT
Grade GPA Ltr Grade
2 100 4.0 A
3 99 4.0 A
4 98 4.0 A
5 97 4.0 A
6 96 3.7 A-
7 95 3.7 A-
8 94 3.5 B+
9 93 3.5 B+
10 92 3.0 B
11 91 3.0 B
12 90 3.0 B
13 89 2.7 B-
14 88 2.7 B-
15 87 2.7 B-
16 86 2.5 C+
17 85 2.5 C+

Please write back.....
Thanks,
Cindy