Weird Excel (Numbers, actually) Question

[pianodude123]

I am setting up a new budget spreadsheet, and I have some cells that I want the following to happen:

Once I enter in a trigger value in cell A1, a bunch of other cells in the same row have calculations done, and values assigned to their cells. The problem is, however is that if I were to change the modifier value, the values that I had already entered would also change. So what I am trying to do is make it so that once I enter in the number I want in A1, the formula calculates and in the other cells, inserts the proper value, and then deletes the formula so that just the values from the original calculation remain. Thus, the cells automatically "unlink" themselves from the formula. Is this possible?

 

[GGJstudios]

So what I am trying to do is make it so that once I enter in the number I want in A1, the formula calculates and in the other cells, inserts the proper value, and then deletes the formula so that just the values from the original calculation remain. Thus, the cells automatically "unlink" themselves from the formula. Is this possible?

No.

 

[-aggie-]

The only way you could do it would be to add a macro to the spreadsheet that would remove the links.

 

[demingy]

The closest thing I can think of would be a copy -> paste special where you select "value" in the paste special options.