# Office percentage calculation in excel – this is how it works

You want to calculate in Excel not only with whole numbers, but also with percentages? We show you how it works. For many arithmetic operations, percentages instead of whole numbers are necessary or at least the best choice. Since calculating percentages by hand can be very m&#xFC;hselig, Excel offers here a good assistance. In the following we have compiled some tricks around percent calculations in Excel f&#xFC;r you.

### Convert decimals to percentages

Select the cell(s) you want to convert to percentages. Then click at the top of the men&#xFC;bar in the tab"Start" on the percentage sign. Here all numbers are converted automatically. Alternatively you can k&#xF6;nnen also the key combination [Ctrl] + [Shift] + [%] use.

Attention: Since percentages are usually given as decimal numbers from 0 to 1, Excel here equates the number 1 with 100%.

### Percentage ratios specify

Here you can&#xF6;nd both how many percent of a whole a certain part makes up, and a&#xC4;change between two numbers in percent.

In the following image you can see that the cell with the total has been divided by the cell with the share. This then gives you a decimal number, which you can convert to a percentage using the method described above&#xF6;n.

The next picture shows you how to calculate a change in percent. In the example, we want to determine the ratio of the sales from year 2 to the sales in year 1. To do this, divide the revenue from year 2 by the revenue from year 1 and show the whole as a percentage. If you want to see only the increase or the loss, you can label another field. Here m&#xFC;ssen you =100-[cell name] write in. In the placeholder for the cell name, simply enter the cell that shows the percentage ratio (in the example, C6).

### Calculate percentages

For example, if you want to add a tax or commission to your income, you can&#xF6;nt do that easily either. Just write down your amount and the corresponding percentage.

In the example, you want to calculate how big&#xDF; the final amount is after adding the value-added tax. The VAT is given as 0.19, which&#xFC;s converted to the percentage 19% using the above method. In the C2 field, calculate how much tax is due by multiplying the net cost by the tax rate. &#xDC;via this method you can also calculate in general how large&#xDF; a certain percentage of a total is.

You can&#xF6;nnen also calculate how high the final amount ausf&#xE4;llt. To do this, add the tax amount calculated above to the net costs in a new cell. If you are not interested in the intermediate step of calculating the amount of tax, you can also do a direct calculation where you work out the amount of tax and add it directly to the net cost. This is how you get the gross amount.