QEC UAF
CS-301 Computer Science and Information TechnologyInstructor: Aysha Rafiqe Rest of the part “How to make salary sheet in Excel”We calculated all allowances in the last lecture. Now start from Gross Salary.Gross Salary is the salary which can be calculated to sum up the basic salary and all allowances. In the below picture for calculating basic salary we use the formula sum to add the basic salary and all allowances.After writing formula then press enter key. Gross salary will be calculated like in the below picture.After this, drag the column below, all employees gross salary will be calculated automatically as shown below.After that, we have to calculate income tax, Income tax depends on the organization, what criteria they choose for income tax, we supposed that we have to calculate 10% income tax of the gross salary. Remember students, Income tax would be calculated of Gross Salary not basic salary. As shown below.Here is same method to calculate income tax, like other taxes we calculated earlier. In the below picture after entering formula, press enter , income will be calculated and then drag the column.Last thing, we have to calculate net salary. Net salary is obtained by subtracting income tax from our Gross salary. After applying this formula, press enter.Now, Drag the column and net salary of all the employees will be calculated automatically.Thank You. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.