Employee Salary Calculation
"Write formula using cell name for the following expression. State where the
formula is placed.
i. Basic Pay = Working Days * Rate.
ii. Allowance are allocated at 10% of the Basic Pay.
iii. Gross Pay = Basic Pay + Allowances.
iv. Tax Deduction is calculated at 10% of the Gross Pay.
v. Net Pay = Gross Pay – Tax Deductions – NSSF Contributions.
NSSF 🡪 National Small Savings Fund (Rate @5%),
(All this rates are an example it would be changed as per company rules.)"
