Support Board
Date/Time: Fri, 24 Oct 2025 02:42:26 +0000
Post From: Spreadsheet programming - locking one time event
| [2020-04-07 19:30:41] |
| Sawtooth - Posts: 4278 |
|
Try this in Q3: =IF(K3=0,0,IF(AND(K4=0,K3>0),B3,Q4)) This will make the Open price persistent in column Q when K3 goes true, and return to 0 when K3 goes false. You'll need a separate Formula Column for each of the 4 values. You can use the shorter B3, C3, D3, E3 instead of ID0.SG1@3, ID0.SG2@3, ID0.SG3@3, ID0.SG4@3 |