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.

Office percentage calculation in excel - this is 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ühselig, Excel offers here a good assistance. In the following we have compiled some tricks around percent calculations in Excel für you.

Convert decimals to percentages

Select the cell(s) you want to convert to percentages. Then click at the top of the menübar in the tab"Start" on the percentage sign. Here all numbers are converted automatically. Alternatively you can kö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önd both how many percent of a whole a certain part makes up, and aÄ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ö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ü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önt do that easily either. Just write down your amount and the corresponding percentage.

In the example, you want to calculate how bigß the final amount is after adding the value-added tax. The VAT is given as 0.19, whichü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. Üvia this method you can also calculate in general how largeß a certain percentage of a total is.

You canönnen also calculate how high the final amount ausfä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.

Like this post? Please share to your friends:
Leave a Reply

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: