Is it possible to block a cell with a formula in tables so that the data in the cells changes and the formula keeps the value with the old data?

N

Noir2019-07-02 10:22:12

Google Sheets

Noir, 2019-07-02 10:22:12

it is possible to block a cell with a formula in tables so that the data in the cells changes and the formula keeps the value with the old data

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

Roman, 2019-07-03
@PolarBearGG

Either you write a specific value in the formula instead of a reference, or you save it in a certain "base" - another sheet, for example.
No other way