jesusespinoza1
New Member
- Joined
- Jun 24, 2015
- Messages
- 12
A | B | C | D | E | F | G | |
1 | JOB | Operator 1 | |||||
2 | Current rate | $10.00 | |||||
3 | Next Rate | ||||||
4 | Max | Rate 1 | |||||
5 | Operator 1 | 12.00 | 9.00 | 9.75 | 10.50 | 12.00 | |
6 | Operator 2 | 15.00 | 10.00 | 12.00 | 14.00 | 15.00 | |
7 | Operator 3 | 13.00 | 8.50 | 10.25 | 12.00 | 13.00 | |
8 | |||||||
9 |
<tbody>
</tbody>
I have a compensation spreadsheet that has current wages and the salary structure for the upcoming year. I need to create a formula that will look up the job title and give me the next rate of pay based on the current pay. Lets say EE #1 is a Operator 1 making $10.00 per hour now. I want the formula to look up the pay range for Operator #1 and locate the next pay rate above $10.00. If the current rate is above the max rate then return the max rate