Support Board
Date/Time: Sat, 08 Feb 2025 19:07:15 +0000
Post From: Spreadsheet formula incorrectly evaluating true?
| [2020-07-16 15:04:04] |
| Sawtooth - Posts: 4173 |
|
Column S is a Formula Column, so you can't enter a formula in S8. All formulas in Formula Columns must be entered in row 3. Also, when referencing column J in a Formula Column formula, you must use absolute references to column J cells. Your observation is correct that it is evaluating TRUE for a split second, so using 'Locking a TRUE state' can't do what you want. J6 goes non-zero when you have a naked position. Try this in J29: =J6<>0 Date Time Of Last Edit: 2020-07-16 15:10:30
|