Support Board
Date/Time: Wed, 05 Nov 2025 04:32:44 +0000
Post From: Spreadsheet function to memorize values
| [2019-02-09 15:13:29] |
| Sawtooth - Posts: 4285 |
|
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
|