What is the formula to calculate salary in Excel?

The basic pay is usually 40% of gross income or 50% of an individual’s CTC. Basic salary = Gross pay- total allowances (medical insurance, HRA, DA, conveyance, etc.)

Multiply Regular Hours by Hourly Rate Click cell “F1” and type “Regular Salary.” Press “Enter.” Click cell “F2” and type “=E2*C2” in the cell. Press the “Enter” key. This formula multiplies the employee’s regular hours by his hourly rate.

How is Average Salary calculated? You can calculate the average base, mean salary, or average salary by adding all the salaries for a select group of employees and then dividing the sum by the number of employees in the group .