Formula for increase %

KC

New Member
Joined
Apr 25, 2002
Messages
2
I'm at working and trying to find the formula for percentage increase, 1992-03, 16; 2001-02, 20. I've tried a couple of things but the % number has too many digits. Can you help me with the formula.

KC
This message was edited by KC on 2002-04-26 06:58
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
KC, I don't understand the question, so others may not either. Can you reiterate?

Give us an exact example using cell references, etc.
 
Upvote 0
Hi,

=(Ending Value - Beginning Value) / Beginning Value

then subtract 1

=((B1-A1)/A1)-1

should work.

Bye,
Jay
 
Upvote 0
On 2002-04-26 07:04, Jay Petrulis wrote:
Hi,

=(Ending Value - Beginning Value) / Beginning Value

then subtract 1

=((B1-A1)/A1)-1

should work.

Bye,
Jay

Hi Jay:
If I understood correctly, the OP is trying to find the % increse from figures of 16 and 20, so if A1=16, B1=20 -- then % increase would be:

=(B1-A1)/A1 formatted as % will give 25%

If this is the case then your formula
=((B1-A1)/A1)-1 should be =(B1-A1)/A1

It is simplistic but I just wondered whether I had understood it correctly.

Regards!
Yogi Anand
 
Upvote 0
On 2002-05-01 14:42, Yogi Anand wrote:
On 2002-04-26 07:04, Jay Petrulis wrote:
Hi,

=(Ending Value - Beginning Value) / Beginning Value

then subtract 1

=((B1-A1)/A1)-1

should work.

Bye,
Jay

Hi Jay:
If I understood correctly, the OP is trying to find the % increse from figures of 16 and 20, so if A1=16, B1=20 -- then % increase would be:

=(B1-A1)/A1 formatted as % will give 25%

If this is the case then your formula
=((B1-A1)/A1)-1 should be =(B1-A1)/A1

It is simplistic but I just wondered whether I had understood it correctly.

Regards!
Yogi Anand

Hi Yogi,

Oops! Yes, a careless error. I am usually taking these numbers into a GEOMEAN function, or something like that, so I need to add one to the result, raise it to the right power, and then subtract one. Obviously not the case here.

Nice catch. Thanks for keeping me on my toes.

B1/A1 - 1
would also work

Bye,
Jay
This message was edited by Jay Petrulis on 2002-05-01 15:27
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top