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).
—–
Ted

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

    4 weeks 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
    4 weeks 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
    4 weeks 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.

    4 weeks 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.

Leave a New Comment Related to "How Do I Permanently Save a Formula Generated Value In Numbers?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)