Ravi Sir's Cards › Excel
Salary Slip Generator in Excel (card 1 of 2)
Revision card 1 for Salary Slip Generator in Excel: Gross earned: =SUM(E5:I5) gives ₹40,000; Days in the salary month: =DAY(EOMONTH(B4,0)) gives 31; PF 12% of earned basic up to the ceiling: =ROUND(MIN(E5,Setup!$B$11)*Setup!$B$12,0) gives ₹2,880. Includes an example data table.
Read card text
What this card says
1 for Salary Slip Generator in Excel: Gross earned: =SUM(E5:I5) gives ₹40,000
Days in the salary month: =DAY(EOMONTH(B4,0)) gives 31
PF 12% of earned basic up to the ceiling: =ROUND(MIN(E5,Setup!$B$11)*Setup!$B$12,0) gives ₹2,880. Includes an
Example
data table
Learn this in the lesson: Salary Slip Generator in Excel: Employee Master, Monthly Inputs and a Printable Payslip for Any Employee