Hi hope someone can help. I need to generate a percentage increase and decrease for some figures.for example2005 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.
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'.
Posted before I was ready!Format cell C1 as 'Percentage'. This will work for increases as well as decreases.
Many thanks for that, great help.
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
In Business Circles this is known as % of change Beynac has the right answer.
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.
OnePlus 6 review: Hands-on
How to add texture to hand-drawn artworks
Best free iPad apps 2018
Comment créer un compte PayPal pour payer en ligne ?
© Copyright 2018 IDG UK. All Rights Reserved.