Ravi Sir's Cards › Excel
Payroll Calculator in Excel (card 1 of 2)
Revision card 1 for Payroll Calculator in Excel: Days in the payroll month: =DAY(EOMONTH(B4,0)) gives 31; Gross earned: =F5+G5+H5 gives ₹40,000; PF wages capped at the ceiling: =MIN(F5,Setup!$B$11) gives ₹24,000. Includes an example data table.
Read card text
What this card says
1 for Payroll Calculator in Excel: Days in the payroll month: =DAY(EOMONTH(B4,0)) gives 31
Gross earned: =F5+G5+H5 gives ₹40,000
PF wages capped at the ceiling: =MIN(F5,Setup!$B$11) gives ₹24,000. 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