+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    54

    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
    Last edited by Steve1977; 02-22-2021 at 08:02 AM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

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

    Try this:

    =26*(1+7.86%)
    Last edited by Phuocam; 02-22-2021 at 08:12 AM.

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

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

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

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    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
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    05-16-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    54

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

    Quote Originally Posted by Sam Capricci View Post
    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. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 11-07-2017, 09:48 AM
  2. Replies: 4
    Last Post: 03-11-2014, 12:28 AM
  3. [SOLVED] How can I calculate the base cost after nth year percentage increases?
    By gklrgibson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2013, 07:27 AM
  4. Replies: 3
    Last Post: 09-28-2013, 05:18 PM
  5. Macro that increases a cell value by a certain percentage
    By Jehanzaib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2013, 07:55 AM
  6. Replies: 5
    Last Post: 04-07-2011, 10:57 AM
  7. How to record percentage increases in materials costing sheet.
    By onesonya in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-07-2005, 03:05 AM

Tags for this Thread

Bookmarks

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