98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Percentage difference
Percentage difference
Resolved · Urgent Priority · Version 2003
Tue 2 Dec 2008, 16:08Delegate Anne said...
Anne has attended:
Excel Introduction course
Percentage difference
Hi
How would you work out the percentage difference between two cells (for example A1 and B1)? Is there a pre-programmed formula for this?
Many thanks
Anne
Tue 2 Dec 2008, 16:37
Edited on Tue 2 Dec 2008, 16:38Trainer David said...
RE: Percentage difference
Hi Anne
You will learn a lot more about these types of formulas in the Intermediate course if you are looking to do this training. I would do this formula as follows:
If A1 is 100
and B1 is 90
and I want to show percentage difference in cell C1.
My formula would read =((B1-A1)/A1)
You would also need to format the cell to be a percentage.
You can do this by clicking the Percent Style button it looks like a percent symbol, or by going format/cells/percentage.
I hope that helps and answers your question.
David
Tue 2 Dec 2008, 17:51Delegate Anne said...
RE: Percentage difference
Hi
I'm still confused. Wouldn't the percentage difference in the above case be 10%? Using your formula I get -0.1%
Below are some of the figures I'm dealing with:
A1 = 753.50
B1 = 600.00
C1 = percentage difference between A1 & B1???
A2 = 11.60
B2 = 12.92
C2 = percentage difference between A2 & B2???
Thanks
Anne
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
