Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 05:28:48 +0000
Post From: spreadsheed by mistake
| [2020-01-12 18:23:31] |
| Sawtooth - Posts: 3993 |
|
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.) |