Ravi Sir's Cards › Excel
Payroll Calculator in Excel (card 2 of 2)
Revision card 2 for Payroll Calculator in Excel: Net pay: =I5-SUM(K5:O5) gives ₹35,720; Employee PF 12%: =ROUND(J5*Setup!$B$12,0) gives ₹2,880; Employer share to EPS 8.33%: =ROUND(J5*Setup!$B$13,0) gives ₹1,999. Includes an example data table.
Read card text
What this card says
2 for Payroll Calculator in Excel: Net pay: =I5-SUM(K5:O5) gives ₹35,720
Employee PF 12%: =ROUND(J5*Setup!$B$12,0) gives ₹2,880
Employer share to EPS 8.33%: =ROUND(J5*Setup!$B$13,0) gives ₹1,999. Includes an
Example
data table
Learn this in the lesson: Payroll Calculator in Excel with PF, ESI and Professional Tax: Employer Cost, Statutory Dues and Bank Transfer List