excel salary calculation

  1. R

    Salary Distribution and 3 percent increment every year on hire date

    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...
  2. D

    Managing Department Salaries and Yearly Percent & Dollar Difference

    Before I give up and just use a pivot table to do this. Is there a way, without a pivot table, to calculate the percent salary (column F) difference in column H and the hourly dollar (column G) difference in column I, for the previous year? I know I can do this with a pivot table by only using...
  3. G

    Need Salary Calculation from Net Salary to Gross Calcuation

    Hi, I'm looking for salary calculator which calculate Gross Salary if we input Net Salary. The Components bifurcation is as follows: Basic Salary: 70% of Gross Salary HRA: 30% of Basic Salary ESIC: Gross Salary*0.25%(if Gross salary is Greater than 21,000, ESIC=0) EPF:Basic Salary*12%(If Basic...

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.
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.
Go back
Back
Top