# Percentage increases between two numbers - then applying that percentage to another cell

1. ## Percentage increases between two numbers - then applying that percentage to another cell

Have a feeling there might be an easy answer to this but struggling with the last part.

Currently I have two values
COLUMN A_new ....- ....COLUMN B_old
£13.31........................ £12.34

I've used this formula to calculate percentage increase:
=(New Price-Old Price)/Old Price

Which gives me a percent difference of 7.86%

However I want to then apply a percentage increase of 7.86% to another cell which currently shows £26.00

If I use this formula: =SUM(O3+N3) (with O3 holding the 7.86% answer and N3 having the value I need to amend), it works out as £26.08.

But increasing £26 by 7.86% should equal £28.04

Thank you for any help in advance

2. ## Re: Percentage increases between two numbers - then applying that percentage to another ce

Try this:

=26*(1+7.86%)

3. ## Re: Percentage increases between two numbers - then applying that percentage to another ce

sounds like you want to use: =N3*(1+O3)

4. ## Re: Percentage increases between two numbers - then applying that percentage to another ce

try it this way ...=(1+O3)*N3 assuming O3 has the 7.86% and N3 has the 26.00

5. ## Re: Percentage increases between two numbers - then applying that percentage to another ce

Originally Posted by Sam Capricci
try it this way ...=(1+O3)*N3 assuming O3 has the 7.86% and N3 has the 26.00
Cheers everyone, all replies were very much appreciated but this way was perfect as it automatically showed the total value. Thank you.

6. ## Re: Percentage increases between two numbers - then applying that percentage to another ce

Glad I could help, AND thank you for the rep!

There are currently 1 users browsing this thread. (0 members and 1 guests)