Support Board
Date/Time: Fri, 27 Dec 2024 18:21:19 +0000
[User Discussion] - Formula help
View Count: 625
| [2016-03-07 23:55:11] |
| User713273 - Posts: 409 |
|
Hi-Im currently trying to reference the cell prior, so cell 3 would reference cell 4. What am I doing incorrect here. I know SC support doesnt offer formula help but any user help would be great. thx =OFFSET(ID2.SG1@3,4,0)>OFFSET(ID2.SG1@3,4,0 |
| [2016-03-08 00:20:05] |
| Sawtooth - Posts: 4143 |
|
This is comparing the same cell to itself, because the offset is 4 rows from row 3 on both sides of > : =OFFSET(ID2.SG1@3,4,0)>OFFSET(ID2.SG1@3,4,0) =ID2.SG1@3>ID2.SG1@4 would compare the cell prior to its subsequent. |
To post a message in this thread, you need to log in with your Sierra Chart account: