MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Permanently Save a Formula Generated Value In Numbers?

Is there a way to permanently capture a formula generated value prior to it changing again via the formula?

Example: If my cell formula is A1+B1=4; I want to, prior to it being changed via the formula, permanently preserve the value “4” (in another cell and not subject to change by the original formula).

Comments: 6 Responses to “How Do I Permanently Save a Formula Generated Value In Numbers?”

    2 years ago

    You can set that other cell to mimic the first one. So if that formula is in C1, then in D1 you can put =C1. So now D1 shows what C1 has.

    Then, select D1. Edit, Copy. Then with D1 still selected choose Edit, Paste Formula Results.

    Ted Premer
    2 years ago

    I’m aware of your suggested solution. I don’t want the user to have to do this edit. Also, I need the “preserved value” in another formula. Am I asking for a Numbers impossible?
    Thks Gary for response . . . any other suggestion?

    Ted Premer
    2 years ago

    To put it more simply, I’m trying to accomplish exactly what you suggested . . . but do it via a formula or function. Not by keyboard entry.
    Thks again.

    2 years ago

    Ted: There's no way to do that via a formula. Spreadsheets don't work that way. Formulas are "live" and don't know on their own when to switch from a formula to a number.
    So maybe if I knew WHY you wanted to do this I could make a suggestion. You kinda skipped that part of the question, just restating the question as an example.

    2 years ago

    I have the same question, and my reasoning is that I'd like to delete certain rows based on a criteria.

    I have a function which prints "DUP" based on certain criteria. If the output of the function was permanent, I could then sort the column and remove all rows containing "DUP" which are grouped. However, since the function is based on a relationship between the rows (i.e. a duplicate entry, determined by comparing row values), sorting the data changes which row is identified a duplicate.

    2 years ago

    Mina: so did my initial response above solve the problem for you?

Comments Closed.