# 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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Replies
2
Views
162
Replies
3
Views
248
Replies
0
Views
311
Replies
7
Views
425
Replies
10
Views
803

1,171,035
Messages
5,873,411
Members
432,978
Latest member
blackbird999

### 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