what Formula or Function do I use


T

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
 
Ad

Advertisements

T

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,D1:D7)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top