need help with formula
 

I'm trying to figure out if there's a formula I can use to auto-enter my GPA
on a spreadsheet I have for school.

I have a column with my current grade percent and a table that shows the
percent ranges with the corresponding GPA....(i.e. my grade column shows
96.00% and the table shows 90-100% equal to 4.0 89-85% equal to 3.5 etc)

Is there a way to have excel look at the 96.00% then reference the
percentage range in the table and auto-enter into another cell the
corresponding GPA?

need help with formula
 

Say your datalist is in Y1 to Z9, with the GPA in Z1 to Z9, and the *lower*
grade percent of the range in Y1 to Y9, sorted ascending:

For example, Y1 to Y9:
0, 55, 60, 65, 70, 75, 80, 85, 90

And Z1 to Z9:
0, 0.5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0

With a grade percent in A1, enter this formula in say B1 to return the GPA
to B1:

=LOOKUP(A1,Y1:Z9)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"sn0w0wl" wrote in message
...
I'm trying to figure out if there's a formula I can use to auto-enter my
GPA
on a spreadsheet I have for school.

I have a column with my current grade percent and a table that shows the
percent ranges with the corresponding GPA....(i.e. my grade column shows
96.00% and the table shows 90-100% equal to 4.0 89-85% equal to 3.5 etc)

Is there a way to have excel look at the 96.00% then reference the
percentage range in the table and auto-enter into another cell the
corresponding GPA?