Salary Slip Format In Excel With Formula

Posted on by admin
Salary Slip Format In Excel With Formula Rating: 4,8/5 9582 reviews

Related Articles

Salary slip is the transaction record provide by the organization to its employee in against to evidence of salary being paid. Salary Slip Format in Excel helps your understanding about how to create these slips on MS Excel. While generating your bills and slips with computerize system.

  • 1 Compute Annual Gross Pay in Excel
  • 2 Calculate Employee Payroll
  • 3 Make an Excel Formula to Calculate Overtime
  • 4 Calculate Net Pay from Gross Pay

Using formulas in Microsoft Excel is a reliable method to calculate payroll for your business. Microsoft Excel contains over 300 built-in formulas to aid in the production of a functional worksheet. The 'IF' function is a logical test that assess whether a certain condition is met and returns a value according to the conditions. Using the 'IF' function in your worksheet, you can evaluate an employee's hours, determine the number of overtime hours and calculate the employee's gross salary.

Open a Microsoft Excel Spreadsheet

Open a Microsoft Excel spreadsheet.

Enter Employee Names

Click cell 'A1' and type 'Employee.' Press the 'Enter' key. Click cell 'A2' and type the name of the first employee. Continue entering each employee's name in column A.

Enter Employee ID Numbers

Click cell 'B1' and type 'Employee ID.' Press 'Enter.' Click cell 'B2' and type the employee ID of the first employee. Continue entering each employee's ID in column B.

Enter Employee Hourly Rates

Click cell 'C1' and type 'Hourly Rate.' Press the 'Enter' key. Click cell 'C2' and type the hourly rate of the first employee. Continue entering each employee's hourly rate in column B.

Enter Employee Total Hours

Click cell 'D1' and type 'Total Hours.' Press the 'Enter' key. Click cell 'D2' and type the total hours of the first employee. Continue entering each employee's total hours in column C.

Display Employee Regular Hours

Click cell 'E1' and type 'Regular Hours.' Press the 'Enter' key. Click cell 'E2' and type '=IF(D2>40,40,D2).' Press the 'Enter' key. This formula instructs Excel to display only the employee's regular hours.

Copy the Formula for Each Employee

Click cell 'E2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'E2' and drag your mouse to copy the formula for each employee.

Multiply Regular Hours by Hourly Rate

Click cell 'F1' and type 'Regular Salary.' Press 'Enter.' Click cell 'F2' and type '=E2*C2' in the cell. Press the 'Enter' key. This formula multiplies the employee's regular hours by his hourly rate.

Copy the Formula for Each Employee

Click cell 'F2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'F2' and drag your mouse to copy the formula for each employee.

Display Hours Over 40

Click cell 'G1' and type 'Overtime Hours.' Press 'Enter.' Click cell 'G2' and type ' =IF(D2>40,D2-40,'0')' in the cell. Press the 'Enter' key. This formula evaluates the employee's total hours and displays only hours over 40. If the employee has less than 40 hours, the cell displays a '0.'

Copy the Formula for Each Employee

Download inazuma eleven sub indo lengkap. Click cell 'G2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'G2' and drag your mouse to copy the formula for each employee.

Multiply Overtime Hours by Overtime Rate

Click cell 'H1' and type 'Overtime Salary.' Press the 'Enter' key. Click cell 'H2' and type '=(C2_1.5)_G2' in the cell. Press 'Enter.' This formula multiplies the employee's overtime hours by the general overtime rate of time and a half.

Product keys are required for installation of Autodesk products and are used to differentiate products that are both sold independently and as part of a product suite. The same version of AutoCAD is in both software packages but the product key differentiates one package from the other. Xf adsk 2018 mac torrent. For example, installing AutoCAD 2018 as a point product requires product key 001J1, but installing AutoCAD 2018 from the AutoCAD Design Suite Premium 2018 requires product key 768J1. Note: Please ensure you are using the correct product key for the Autodesk product and version you are installing.

Copy the Formula for Each Employee

Click cell 'H2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'H2' and drag your mouse to copy the formula for each employee.

Add Regular Salary and Overtime

Click cell 'I1' and type 'Gross Salary.' Press 'Enter.' Click cell 'I1' and type ' =H2+F2' in the cell. Press the 'Enter' key. This formula adds the employee's regular salary and any overtime.

Copy the Formula for Each Employee

Click cell 'I2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'I2' and drag your mouse to copy the formula for each employee.

Format the Cells to Dollars

Click cell 'C2' and drag your mouse to highlight each employee's hourly rate. Click the 'Home' tab and click the '$' sign in the 'Number' group to format the cells to include a dollar sign and increase the number to two decimal places. Apply this format to the dollar amounts in column 'F,' 'H' and 'I.'

Apply Formatting to Cells

Click cell 'A1' and drag your mouse to cell 'I1.' Click the 'Home' tab and click the 'B' sign in the 'Font' group to apply bold formatting to the cells.

Tip

  • If an employee is a salary employee and does not have an hourly rate nor receives overtime for hours worked over 40, type the employee's salary amount in column 'F.'

References (2)

About the Author

Angela M. Wheeland specializes in topics related to taxation, technology, gaming and criminal law. She has contributed to several websites and serves as the lead content editor for a construction-related website. Wheeland holds an Associate of Arts in accounting and criminal justice. She has owned and operated her own income tax-preparation business since 2006.

Cite this Article
Choose Citation Style
M., Angela. 'How to Calculate the 'Gross Salary' for Each Employee By Using a Formula.' Small Business - Chron.com, http://smallbusiness.chron.com/calculate-gross-salary-employee-using-formula-12492.html. 11 March 2019.
M., Angela. (2019, March 11). How to Calculate the 'Gross Salary' for Each Employee By Using a Formula. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/calculate-gross-salary-employee-using-formula-12492.html
M., Angela. 'How to Calculate the 'Gross Salary' for Each Employee By Using a Formula' last modified March 11, 2019. http://smallbusiness.chron.com/calculate-gross-salary-employee-using-formula-12492.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.