How to save first record in google spreadsheet cell?

Question

Google Sheets

Hello, I really need your help, here is a brief explanation of the problem. There are three columns: SUM, PRICE, RESULT. In the SUM column, the values ​​will be pulled automatically from other sheets. The value in the PRICE column will constantly change, and in the RESULT column there will be a formula: SUM / PRICE. Example: SUM - 100; PRICE - 2; RESULT - 50. But if the price changes, then the result will be correspondingly different, and I need to save the first result so that I can work with it later. How can this be implemented, otherwise I'm stuck at this place. Please help me figure it out.

Answer 1

This cannot be done with formulas.
But I think you can use scripts . The documentation is voluminous, I didn’t work with this, so I can’t show an example :(