How to Create a Tax Calculator in Excel

Written by jenny holland
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a Tax Calculator in Excel
(Siri Stafford/Digital Vision/Getty Images)

Excel, the spreadsheet portion of Microsoft's Office Suite, has multiple business and personal uses including tax calculations. It's also a timesaver since the user does not have to refer back to the tax calculations made on a regular calculator.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Type the first category in the first cell (box A:1). The first row will include the titles of your categories for each column.

  2. 2

    Label one column “Taxes” and the one next to it the title of the dollar values taxes are applied to. (Example: First column labelled “Sales” in cell A:1, second column “Taxes” in cell B:1)

  3. 3

    Hold the left click of the mouse on cell B:2 and drag the mouse down the middle to highlight the cells.

  4. 4

    Right click on the selected cells. Select "Format cells" from the menu that pops up. Under category select "Percentage" and click "OK." This will format the taxes as a percentage.

  5. 5

    Type the percentage amount (example 10) in cell B:2. The program will automatically make it a percentage and show "10%." Select the box that has "10%" and left click on the small square located at bottom right side of the cell and drag down. The "10%" figure will appear in each box in that column.

  6. 6

    Type the title that will label the tax amount in cell C:1 (this is the column that will have the calculated tax amount). Type =A:2*B:2 in cell C:2 (the cell under the title) or type = and select cell A:2 Type * and select B:2.

  7. 7

    Click and drag from the bottom right of the cell with the equation (C:2) so the whole column now has the same calculation that will be used for the tax for any amount typed in column A. Input the data to calculate the tax on.

Tips and warnings

  • The style and format of the spreadsheet can be changed as long as you use the percentage and multiplication steps.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.