How To Calculate Basic Salary In Excel 3 Methods Exceldemy We want to calculate the basic salary from this percentage. steps: enter the following formula to the cell where you want to get your desired output: =c5*d5. here, c5 = ctc. d5 = basic salary percentage of ctc. press enter. use autofill to drag the formula to every cell you want to get the output. Method 3 – adding a generic formula to calculate the prorated salary in excel. steps: select e5. enter the following formula in the selected cell. =d5 c5 1. press enter. drag down the fill handle to see the result in the rest of the cells. this is the output. enter the following formula in f5.
How To Calculate Basic Salary In Excel 3 Methods Exceldemy Method 3 – using a generic formula to calculate da on basic salary. we’ll use the simple dataset to calculate a da as 12% of the salary. steps: select cell d5. insert the following formula. =(c5*12) 100. we have multiplied salary by 12 and then divided it by 100. press enter to get the value of dearness allowance. In this video, i'll guide you through three methods to calculate a basic salary. you'll learn about using gross salary, using ctc, and deducting pf to calcul. This tutorial demonstrates how to make a salary sheet in ms excel with formulas and a pivot table summary with an easy to follow example and takes you step b. The formula for calculating basic salary from gross salary would be: basic salary = gross salary (all the allowances benefits bonuses, etc.) example: mr a receives a gross salary of rs. 10,00,000, out of which allowances amount to rs. 1,00,000, a bonus amounts to rs. 1,50,000, and overtime pay amounts to rs. 50,000.
How To Calculate Da On Basic Salary In Excel 3 Easy Ways Exceldemyо This tutorial demonstrates how to make a salary sheet in ms excel with formulas and a pivot table summary with an easy to follow example and takes you step b. The formula for calculating basic salary from gross salary would be: basic salary = gross salary (all the allowances benefits bonuses, etc.) example: mr a receives a gross salary of rs. 10,00,000, out of which allowances amount to rs. 1,00,000, a bonus amounts to rs. 1,50,000, and overtime pay amounts to rs. 50,000. Solution: the formula for calculating gross salary from basic salary is: gross salary = basic salary hra (house rent allowance) other allowances. according to the above data: gross salary = 45,000 2,000 1,500 1,000. = 50,000. result: the gross salary of mr. x is ₹50,000, as shown below. A payslip or salary slip is a document provided by the employer to all the employees. it is a monthly statement that consists of the details about all the components of the salary. all elements of the salary breakup, including the deductions, are enlisted in a payslip or a salary slip. it provides the detailed structure of the salary at a glance.
Comments are closed.