Step 5 – Calculate the Total Deduction from Gross Salary Go to E14 and input this formula: =C14+D14 Press Enter. AutoFill to E18. Step 6 – Calculate the Net Salary to Complete the Monthly Salary Sheet Go to F5 and insert the following formula: =E5-E14 Press Enter. Use the Fill ...