How can I create a percentage increase formula?

K

Karen

I'm trying to creat a percentage increase formula from cells that already
contain percentages. Is that possible.

For instance:

Cell A1: 30%
Cell B1: 40%...

What formula can I create to get the percentage increase of percentage
figures?
 
D

David Billigmeier

Are you speaking of percentage POINTS or just a straight percentage difference?

The percentage point difference would be: =B1-A1, which of course is just 10%

When you ask for the percentage increase/decrease you are implying ratios,
not differences, which would be calculated as follows: =(B1/A1)-1, which is a
33.33% increase.
 
R

Ron Coderre

With
A1: 30%
B1: 40%

If you want the Percent Increase, try this:
=(+B1-A1)/A1

In that instance, the formual returns:
33.33% (Actually: 0.333333333333333)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top