Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 04 Feb 2025 10:50:33 +0000

How to Post a Message for Support

Post From: spreadsheed by mistake

[2020-01-12 18:23:31]
[Go To First Post]
Sawtooth - Posts: 4166
In Formula Columns, you must use an absolute reference to J21:
= AND (((ID0.SG2@3 - ID0.SG3@3) > $J$21 * 10) , ((ID0.SG2@3 - ID0.SG3@3) <= $J$21 * 15))

You can also use fewer parentheses:
= AND (ID0.SG2@3 - ID0.SG3@3 > $J$21 * 10 , ID0.SG2@3 - ID0.SG3@3 <= $J$21 * 15)

And you can use direct cell references for OHLC values:
= AND (C3 - D3 > $J$21 * 10 , C3 - D3 <= $J$21 * 15)

(Note: spaces are only supported in some locations within a formula.)