Blog

How to Calculate a Percentage of a Number

If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of.

For example, if you want to calculate 14.5% of 1000, multiply 14.5% by 1000.

I.e. type the following formula into any Excel cell:

=1000*14.5%

- which gives the result 145

How to Calculate a Percentage as a Proportion

If you want to calculate percentage as a proportion (i.e. calculate the size of a sample, as a percentage of a full set), simply divide the sample size by the size of the full set.

For example,

For the calculation of percentage of Achievement with Target

Target is Rs 8000 and Achievement is Rs 9000

Formula is Achievement/Target  ie. 9000/8000=113% 

How to Calculate Percentage Change

If you want to calculate the percentage change between value a and value b, this is done using the formula:

percentage change = ( b - a ) / a

For calculation  of the Salary change from the old salary to new salary

Percentage Change=(New Salary-Old Salary)/Old Salary

Click here for getting Work book