Here the basic salary will be calculated as per follows Basic Salary + Dearness Allowance + HRA Allowance + conveyance allowance + entertainment allowance + medical insurance here the gross salary 660,000. The deduction will be Income tax and provident fund under which the net salary comes around 552,400 .
Read moreHow do I calculate a salary sheet in Excel?
Examples of Salary Formula (With Excel Template)
Read moreHow is the salary calculated for a month in India?
Since October has 31 days, the per-day pay is calculated as Rs 30,000/31 = Rs 967.74. This is a variant of the Calendar day basis. In this method, the pay per day is calculated as the total salary for the month divided by the total number of calendar days minus Sundays .
Read moreHow do you calculate basic salary in Excel?
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.
Read moreHow do I create a salary sheet in Excel Step by step PDF?
It’s done in the format you want it to be.
Read moreHow do I create a salary sheet in Excel?
The salary slip sheet uses the VLOOKUP Function to program the sheet. On the extreme right, select the name of the employee from the drop-down list. The template displays the salary data of the respective employee. Click on the print button to print the Salary Slip.
Read moreHow do I use Excel to calculate salary?
Examples of Salary Formula (With Excel Template)
Read more