# 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  Register To Reply

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

Try this:

=26*(1+7.86%)  Register To Reply

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

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

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  Register To Reply

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.  Register To Reply

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

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

#### Thread Information

##### Users Browsing this Thread

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

#### Tags for this Thread #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1