Calculate the Salary Per Day in Excel

The following table contains the Name, Designation, and Salary columns.

Formula 1 – Using a Generic Formula to Calculate Per Day Salary in Excel

Steps:

=D5/30

Formula Breakdown

Divide D5 by 30.
$8000/30 → becomes
- Output: $266.67
- Explanation: Here, $266.67 is the Per Day Salary.

Press ENTER and see the result in E5.
Drag down the formula across the cells you want to fill with the Fill Handle tool.

The calculated salary per day is displayed in the Per Day Salary column.

Steps:

Calculate PF (Provident Fund). PF is 10% of the Basic Salary, here.

=C17*10%

Formula Breakdown

C17*10% → multiplies cell C17 by 10%.
$8000*10% → becomes
- Output: $800 is the PF of a particular employee.

Press ENTER and see the result in D17.
Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate the Tax.

=IF(C17>=6000,C17*12%,C17*8%)

Formula Breakdown

IF(C17>=6000,C17*12%,C17*8%) → the IF function returns C17*12% when C17>=6000 is TRUE, otherwise it returns C17*8%.
IF(8000>=6000,8000*12%,8000*8%) → becomes
- Output: $960. As the logical_test is TRUE, the result becomes 8000*12% which is $960.

Press ENTER and see the result in E17.
Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate the Total Deduction.

=SUM(D17,E17)

Formula Breakdown

SUM(D17,E17) → adds cell D17 with cell E17.
SUM(800,960) → becomes
- Output: $1760 is the Total Deduction of a particular employee.

Press ENTER and see the result in F17.
Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate the Net Salary.

=D5+E5-F17

Formula Breakdown

D5+E5-F17 → adds cell D5 to cell E5 and subtracts F17.
8000+1000-1760 → becomes
- Output: $7240 is the Net Salary of a particular employee.