# going to a new pay system

#### MueRen

##### New Member
we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount of production.
 Casting Operator \$16.00 2 Technical 3 Casting Operator \$16.00 2 Technical 3 Draw Bench Operator \$16.00 2 Technical 3 Storeroom Attendant \$16.00 2 Technical 3 Quality Assurance \$16.00 2 Technical 3 Material Handler \$13.00 2 General 1 Material Handler \$14.50 2 General 2 Maintenance Mechanic \$24.00 2 Technical 5 Maintenance Electrician \$27.00 2 Technical 7 FL1 Operator \$16.00 2 Technical 3 Casting Operator \$16.00 2 Technical 3 Casting Operator \$16.00 2 Technical 3 Casting Operator \$16.00 2 Technical 3 Casting Supervisor \$18.00 2 Technical 4 Casting Operator \$16.00 2 Technical 3

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 Production General 1 General 2 Technical 3 Technical 4 Technical 5 Technical 6 Technical 7 Level Pounds / Week G1 G2 T3 T4 T5 T6 T7 7 250,001 - ∞ \$15.00 \$16.50 \$20.50 \$23.00 \$30.50 \$32.00 \$34.00 6 240,001 - 250,000 \$15.25 \$16.25 \$19.00 \$21.50 \$28.50 \$30.00 \$32.00 5 230,001 - 240,000 \$14.50 \$16.00 \$18.25 \$20.25 \$27.00 \$28.75 \$30.50 4 220,001 - 230,000 \$14.00 \$15.50 \$17.50 \$19.50 \$26.00 \$27.50 \$29.50 3 215,001 - 220,000 \$13.50 \$15.00 \$16.75 \$18.75 \$25.00 \$26.50 \$28.00 2 210,001 - 215,000 \$13.00 \$14.50 \$16.00 \$18.00 \$24.00 \$25.50 \$27.00 1 200,001 - 210,000 \$12.25 \$13.75 \$15.25 \$17.00 \$23.00 \$24.25 \$25.50 Base 0 - 200,000 \$11.00 \$12.50 \$14.00 \$15.50 \$21.00 \$22.00 \$23.00

<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
7
Views
136
Replies
10
Views
646
Replies
2
Views
323
Replies
2
Views
214
Replies
1
Views
137

1,130,030
Messages
5,639,641
Members
417,101
Latest member
amoverton2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back