what Formula or Function do I use

[the5sheas]

Hello All,

I need help with the following information from a table to a worksheet:

GPA Points
3.9-4.0 30
3.6-3.8 25
3.3-3.5 20
3.0-3.2 15
2.7-2.9 10
2.4-2.6 5
2.3 0

On the worksheet I add up 3 GPAs from 3 different schools, then get the
average. In the next column I want the average to show and then in the next
column I want the points to automatically appear. I am fine until the final
column - the points.

Michael

 

[T. Valko]

Create a 2 column table like this:

...........C..........D
1........0..........0
2........2.4.......5
3........2.7......10
4........3.0......15
5........3.3......20
6........3.6......25
7........3.9......30

Assume A1 = average

=LOOKUP(A1,C1:C7,D17)

 

[T. Valko]

Ok, good deal!

Thanks for the feedback!