Skip to main content

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

Image for Employee Pay sheet Formulas in Microsoft Excel Software

Employee pay sheet Formulas in MS Excel

 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.

Download the Original Worksheet Prepared For Employee Pay Sheet Formulas

Sponsored Links

Click to Download Excel Workbook For Employee Pay sheet Formulas

Employee Pay sheet is normally required and maintained in every small business organization. There are very simple formulas are used to calculate monthly pay of the employees working in a small business. There is no need to develop a software for this purpose in a small book shop. Because, Microsoft Excel can be very useful to prepare such employee pay sheet with formulas.

Employee Pay sheet Formulas in Microsoft Excel

Here is the
Picture of Complete MS Excel Worksheet on

Employee Pay sheet Formulas in Microsoft Excel

Employees Pay Sheet Formulas Complete MS Excel Worksheet

 

Labels:

Comments

jack said…
YOU HAVE MADE MY DAY
November 24, 2016 at 7:04 PM
Post a Comment

Popular posts from this blog

Bus Topology Advantages Disadvantages

Bus Topology Bus topology is the simplest network topology . In bus topology , all computers in network are connected to a common communication wire. This wire is called BUS. Terminators are used at both ends of wire. Bus Topology is Cheap, easy to handle and implement. Bus Topology require less cable. Bus Topology is best suited for small networks. Working of Bus Topology with Advantages and Disadvantages Advantages of Bus Network Topology 1. It is very simple topology . 2. It is easy to use. 3. It needs small amount of wire for connecting computers. 4. It is less expensive due to small wire needed. 5. If one computer fails, it does not disturb the other computers in network. Other computers will continue to share information and other resources with other connected computers. Disadvantages of Bus Network Topology 1. Only small number of computers can be connected in a bus network . 2. Network speed slows down as the number of computer increases in b...
Post a Comment
Read more

Types Of Headings In HTML

HTML Hedings Headings in HTML are used to display Titles, Sub-Titles of Sub-Sub-Titles for your web page text. There are six types of headings in HTML. H1 is the largest heading and H6 is the smallest heading. <H1> is opening tag whereas </H1> is the closing tag for the largest heading. The text between <h1> and </h1> will be displayed as the main Title in your web page. Following are the six tags used for six types of headings in HTML. <H1> ... </H1> <H2> ... </H2> <H3> ... </H3> <H4> ... </H4> <H5> ... </H5> <H6> ... </H6> The H1 heading is used for main titles. Actually H1 heading will show the text in largest font size. H2 headings is used for Sub-Titles. H2 displays text in smaller font size than H1, H3 displays text of font size smaller than H1 and H2, and so on. H1 is for largest heading in a text page and H6 is for smallest heading.   Importance Of Headings in SEO H...
Post a Comment
Read more

Explain Advantages Of Networks

Define Network with examples. Give importance of Computer Network. COMPUTER NETWORK We can define a Computer Network as a set of two or more connected computers to share information and other resources (data, files, printers, hard disk, modem, CD-Rom Drive, CD-Writer, DVD-Rom Drive, DVD-Writer etc.). The computers in a network can share: Data, Information, Files Software Hardware (printers, disk, modems)etc. Advantages of Computer Networks EXAMPLES OF COMPUTER NETWORK Computer network can be used in an office. Different people in the office can share common information and printer. Net Cafes use Computer Network for internet sharing. Net Cafe Owners can save money by sharing one DSL Routers / Modem and a single Internet Connection. Computer Network is used in Computer Laboratories of Schools, Colleges and other educational institutes. Internet, is also an example of a computer network. Internet is a network of millions of computers connected through phone lin...
Post a Comment
Read more