Support Board

Date/Time: Tue, 21 May 2024 00:12:09 +0000

Post From: Spreadsheet formula incorrectly evaluating true?

[2020-07-16 15:04:04] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4001
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