Table of Contents
📌 Employee Salary Calculation in Excel
We have Employee Name, Basic Salary, D.A (10%), T.A (12%), Gross Salary, P.F (8%), and Net Salary.
| Employee Name | Basic Salary | D.A (10%) | T.A (12%) | Gross Salary | P.F (8%) | Net Salary |
|---|---|---|---|---|---|---|
| John | 30,000 | ? | ? | ? | ? | ? |
| Emma | 40,000 | ? | ? | ? | ? | ? |
| Liam | 25,000 | ? | ? | ? | ? | ? |
🔹 Step-by-Step Formulas for Salary Calculation
1️⃣ Calculate D.A (10%)
=B5*10%
👉 Press Enter, then drag down for all employees.2️⃣ Calculate T.A (12%)
=B5*12%
👉 Press Enter, then drag down.3️⃣ Calculate Gross Salary (Basic Salary + D.A + T.A)
=SUM(B5:D5)
👉 Press Enter, then drag down.4️⃣ Calculate P.F (8% of Gross Salary)
=E5*8%
👉 Press Enter, then drag down.5️⃣ Calculate Net Salary (Gross Salary – P.F)
=E5-F5
👉 Press Enter, then drag down.✅ Now, Excel will automatically calculate the salary details for all employees! 🚀
