# Employee Pay sheet Formulas in Microsoft Excel

Today, we will discuss How to create an Employee Worksheet by using Employee Pay sheet formulas in Microsoft Excel. The following formulas will be used in Employee Pay sheet: Q: Prepare a worksheet according to the following instructions:

1. Create a worksheet in MS Excel according to the requirements
2. Enter sample data of employees in a college
3. Apply formula to calculate Medical Allowance @ 40 % of Basic Pay
4. Apply formula to calculate Conveyance Allowance @ 30 % of Basic Pay
5. Apply formula to calculate House Rent @ 50 % of Basic Pay
6. Add a column of Income Tax @ 7 % of Basic Pay
7. Apply formula to calculate Net Pay = Medical Allowance + Conveyance Allowance + House Rent – Income Tax

## Solution:How to Create Employee Pay Sheet in Excel With Formulas

1. Create a new workbook in MS Excel and save as with the name Employee Pay sheet Formulas.
2. Enter sample data for at least three employees.
3. Enter formula for Medical Allowance = D5 * 40% in cell with cell reference E5.
4. Enter formula for Conveyance Allowance = D5 * 30% in cell with cell reference F5.
5. Enter formula for House Rent = D5 * 50% in cell with cell reference G5.
6. Enter formula for Income Tax = D5 * 5% in cell with cell reference H5.
7. Enter formula for Net Pay = D5 + E5 + F5 + G5 – H5 in cell with cell reference I5.

So, the worksheet with Employee Pay sheet Formulas has been prepared successfully.