Excel question, how to generate percentage figures

  oo7juk 11:52 08 Jun 06
Locked

Hi hope someone can help.

I need to generate a percentage increase and decrease for some figures.

for example

2005 figure 265.30 2006 figure 125.59.Can someone tell me how to generate the percentage decrease, e.g. figure for 2006 decreased by ?%

also looking for the same for increase.

Can this be done on excel.

Many thanks.

  beynac 12:10 08 Jun 06

Divide the difference by the 2005 figure and format the result cell as 'Percentage'. e.g. If 2005 figure is A1 and 2006 figure is B1. In cell C1 put '=(B1-A1)/A1'.

  beynac 12:12 08 Jun 06

Posted before I was ready!

Format cell C1 as 'Percentage'. This will work for increases as well as decreases.

  oo7juk 13:27 08 Jun 06

Many thanks for that, great help.

  Simsy 13:29 08 Jun 06

beynac has said to format the cell as "Percentage". This does 2 things in Excel; it adds the % symbol to the calculated answer, and it also multiplies the answer by 100.

e.g. enter 5 into a cell, (that is formated for general number). Now format it as "Percentage". It changes to 500%. type 0.5 into the cell... it changes to 50%

Apologies if this clouds, rather than clears things for anyone!

Regards,

Simsy

  Cesar 08:40 13 Jun 06

In Business Circles this is known as % of change Beynac has the right answer.

  Simsy 10:59 13 Jun 06

I wasn't suggestion anything was wrong... just pointing out that when using the % format in Excel you need to be careful about the order in which you do things...

If you have a formula whihc actually works out the percentage of something, and THEN format the cell to be % you will get the wrong answer.

Regard,

Simsy

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…