I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee.
We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date. Also want to factor in condition that if any employee joins in current...
Hi,
I'm trying to put together a salary model and need help with a formula which takes into account annual pay rises when calculating each person's monthly costs.
For example, worker 1 starts on a basic pay of £1500 per month but on the 1st August each year receives a 3% pay rise and on 1st...
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.