+ Reply to Thread
Results 1 to 6 of 6

Leave calculated figure unchanged if value in reference cell is changed

  1. #1
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    53

    Leave calculated figure unchanged if value in reference cell is changed

    I have a figure in a cell which a whole column of formula refer to in order to calculate an answer.

    I put a figure in that cell and all is well until that figure has to be changed.

    Then, all calculations already made will change since the formula is now using the new number for its calculations.

    Is there a way that I can tell excel to leave already calculated figures unchanged when a new reference figure is entered and to only use the new number for all new calculations?

  2. #2
    Valued Forum Contributor kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    1,345

    Re: Leave calculated figure unchanged if value in reference cell is changed

    You would need to convert the formulas to values in the cells you don't want to change.

    Using VBA or manually.

  3. #3
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    53

    Re: Leave calculated figure unchanged if value in reference cell is changed

    I was hoping there was a way to do it without deleting the formulas in those cells.

  4. #4
    Valued Forum Contributor kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    1,345

    Re: Leave calculated figure unchanged if value in reference cell is changed

    But if the formulas stay they are no longer correct.

  5. #5
    Valued Forum Contributor
    Join Date
    03-28-2015
    Location
    Utrecht Area, NL
    MS-Off Ver
    2016
    Posts
    408

    Re: Leave calculated figure unchanged if value in reference cell is changed

    looks like time for an example because you cannot have the old result and new result in the same cell so most likely you have a formula that calculates results and results are in multiple cells but previous rows must not change for newly entered numbers

    please provide an an example so we can build a solution on you data instead of mutual assumptions or interpretations of what you mean..
    make sure your data has no personal or other sensitive information.

  6. #6
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    53

    Re: Leave calculated figure unchanged if value in reference cell is changed

    I was hoping there was a way to do this which wouldn't involve changing the formulas or changing the calculated figures into actual entries in the cell in place of the formula. But I don't think there is so I have come up with another solution which works fine. Thanks for your input .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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