Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Calculations dependant on the value of another cell 1

Status
Not open for further replies.

postmanphat

Technical User
Nov 13, 2006
117
GB
Hi,

I've got the following table of pay grades and what the hourly rate is for that pay grade:

Code:
Grade HourlyRate
3	 7.674636175
4	 7.971413721
5	 8.268711019
6	 8.564449064
7	 8.863305613
8	 9.160602911
9	 9.538981289
10	9.834719335
11	10.31237006
12	10.78066528
13	11.26299376
14	11.76195426
15	12.10343035
16	12.45841996
17	12.80821206

Now, I have a s/sheet where next to each member of staff I'm asking them to enter their pay grade (3-17) and how many hours they work per week. In an adjacent cell I'd like Excel to calculate what their weekly pay should be. I can't work out for the life of me how I get it to choose the appropriate value. I've had a play using dlookup but am getting nowhere.

For example: John Smith is grade 7 and works 4 hours a week, so he types '4' in cell B2 (hours) and '7' in cell B3 (paygrade) and at that point Excel would automatically calculate the weekly wage (35.45) in B4 using the appropriate pay grade.

Many many thanks in advance

Dave
 
Use the VLOOKUP formula to get the rate.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
.. or INDEX in case of sequential whole numbers, as in your case (=INDEX(HourlyRateRange,PayGradeEntered-2)).

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top