Support Board
Date/Time: Wed, 15 Jan 2025 21:31:09 +0000
Post From: Spreadsheet recalulate
| [2017-09-15 03:55:32] |
| User29926 - Posts: 92 |
|
ok. This is my issue. I have a cell that is locked to a value and the unlock/reset works if I just check one cell for a value change. But the locked cell won't reset if there are two or more cells being checked that might change to cause a reset of the locked cell value. The reset doesn't even happen when the position size "$J$8=0" goes back to zero. Without the reset,another trade order is placed as soon as $J$8=0 goes back to zero. I need the $H$62 cell to go back to zero when $J$8=0. My current code below: =AND(OR($H$62 =1, IF(AND($HF$90=0, SUM(ID65.SG1@3:ID65.SG1@4)>0),1,0)), OR($J$8=0, OR( $H$90= 0, OR($E$3 = $H$34, OR($E$3 = $H$88, $E$3 < ID17.SG6@3))) ) ) Date Time Of Last Edit: 2017-09-15 04:43:39
|