View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default what Formula or Function do I use

Ok, good deal!

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"the5sheas" wrote in message
...
THANK YOU T. Valko!!!!!! I figured it out. I had the wrong starting column
and cell information. Thanks!!!!

"the5sheas" wrote:

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