Support Board

Date/Time: Mon, 06 May 2024 17:36:32 +0000

Post From: Spreadsheet function to memorize values

[2019-02-09 15:13:29] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
J98 is read only; you can't write to it. If you want to 'remember' a value in column AA, you'll need to use a Formula Column to create a persistent variable. Try this: Cell P3: =IF(AA3>0,AA3,P4) Here are some other examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Other Examples Date Time Of Last Edit: 2019-02-09 15:49:33