# Need help in paying salary increase with specific formula

#### ehlfb

##### New Member
Dear Collegues,

I need your help, I have a list of 1000 employees. I need to pay them an increase of 3% on their salary as per the following criteria:

1. All employee to get 3% increase BUT
2. If the salary is <300 and Year of Services > 3 years the MIN increase should be \$15
3. If the salary is <300 and Year of Services < 3 years the MIN increase should be \$10
4. All other should get 3%

 SALARY JOIN_DATE 233 3-Oct-99 350 1-Mar-03 400 9-May-99 300 2-Jul-00 174 1-Jun-09 242 21-Nov-00 203 10-Jul-05 500 14-Oct-12 600 5-Apr-06 301 25-Jul-04 700 27-Jun-10 214 5-Apr-06 174 19-Jul-09 190 2-May-06 234 7-Jan-01 200 5-Apr-06 197 11-Dec-05 602 30-Mar-72 573 18-May-75 409 2-Oct-90 492 14-Nov-85 385 26-Oct-76 457 11-Aug-79 300 13-May-01

<tbody>
</tbody>

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Hi

Perhaps this:

Excel 2010
ABCDE
1SALARYJOIN_DATESalary IncreaseRef Date31/03/2013
223303-Oct-9915Min %3%
335001-Mar-0310.5Min Salary300
440009-May-9912Min Inc > 3 years15
530002-Jul-009Min Inc < 3 years10
617401-Jun-0915
724221-Nov-1010
820310-Jul-0515
950014-Oct-1215
1060005-Apr-0618
1130125-Jul-049.03
1270027-Jun-1021
1321405-Apr-0615
1417419-Jul-0915
1519002-May-0615
1623407-Jan-0115
Sheet1
Cell Formulas
RangeFormula
C2=MAX(A2*\$E\$2,IF(A2<\$E\$3,IF((\$E\$1-B2)/365>=3,\$E\$4,\$E\$5)))

Note the biggest problem here is making sure of the 3 years' employment rule - because it is an inexact formula used above ((ref date - start date)/365)

Thanks Firefly, it works perfectly. Thanks again and have a nice weekend.

You're welcome

Replies
8
Views
144
Replies
2
Views
125
Replies
3
Views
319
Replies
3
Views
124
Replies
6
Views
377

1,196,042
Messages
6,013,049
Members
441,746
Latest member
ArtemisAlex

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