postmanphat
Technical User
Hi,
I've got the following table of pay grades and what the hourly rate is for that pay grade:
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
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.80821206Now, 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