Percentages and their calculation in Excel

This article is about calculating of percentages in Excel. Let’s see few model examples:

Change

Example

The revenue in January was 55, in February it was 59. How many percent was the increase?

Formula

=(59-55)/55

We are calculating the relation of change to original value.

Result

The revenue was 5,36% higher

Rates

Example

The price without tax is 252. The tax is 21%. What is the price with tax?

Formula

=252*(1+21%)

We want to see the price with tax, which includes price without tax and tax.

Result

The total price with tax is 305.

How many percent from total does the part make?

Example

We have 234 customers, from them 32 is from Europe. How many percent of our customers is from Europe?

Formula

=32/234

Result

13,6752% (=0,136752) of our customers are from Europe.

I know the total, I know the percentage of it and I want to know how big is this part.

Example

I have 8 kitten, 25% from them are tabby. How many tabby kitten do I have?

Formula

=8*0,25 (or =8*25%)

Result

Two kittens are tabby

I know how big is the part and know how many percent is it. What is the total?

Example

In a bottle of 40% whisky is 0,28l of pure alcohol. How big is the bottle?

Formula

=0,28/0,4

Result

The bottle has 0,7 l.

You can download the sheet with examplex.