How to Create an Income Tax Calculator in Excel
Microsoft Excel is a spreadsheet portion of Microsoft Office, which has many different uses, including tax calculations. It is an excellent time saver tool and is simple to use. Here are some steps to help create an income tax calculator in Excel.
- Type a category into the first cell (Cell A). The first row will include different titles of your categories.
- Label the first column "Taxes," and next to it the dollar value of the taxes. For example, with the first column labeled "Sales" in cell A:1, the second column is labeled "Taxes" in cell B:1.
- Hold down the left click of your mouse on cell B:2, and then drag your mouse down the middle of the page so it highlights the cells.
- Right click with your mouse on the highlighted cells. Select "Format" from the pop-up menu. Under Category select "Percentage" and then click "Ok." This will format the taxes as a percentage.
- Type in the percentage amount into cell B:2. The program will automatically make it a percentage. The small square should be located at the bottom right side of the cell. Once you have found the small square you need to drag down on it. By doing this the 10 percent figure will show up in each box that is in that column.
- Type the title that labels the tax amount in cell C:1. Remember this is the column with the calculated tax amount. Type =A:2*B:2 in cell C. (=This is the cell under the title). Or you can type = and then select cell A:2 and type *, and then select B:2.
- Click and drag from the bottom right of the cell that holds the equation (C:2) so the whole column has the same calculation. This will be used for the tax for any amount that is typed into column A. Keep on inputing data to calculate the taxes on.