Calculating Percentages in Excel

 

There are no specific functions for calculating percentages.

You have to use the skills you were taught in your maths class at school!

Finding a percentage of a value

Example 1

A company is about to give its staff a pay rise.

The wages department need to calculate the increases.

Staff on different grades get different pay rises.

Finding a percentage increase

Example 2

A company is about to give its staff a pay rise.

The wages department need to calculate the new salary including the % increase.

Staff on different grades get different pay rises.