Support Board
Date/Time: Wed, 15 Jan 2025 16:23:08 +0000
spreadsheet copy down without reference auto-correcting itself
View Count: 752
| [2017-07-21 08:25:11] |
| traderacademie - Posts: 38 |
|
Hi, I am using the spreadsheet with formulas with referenced cells e.g.: =IF(9<ID2.SG1@3<19,1,0) Then, I use the "copy down" feature to copy the this formula to an adjacent cell and the formula changes to: =IF(9<ID2.SG1@4<19,1,0) So, the reference automatically updates itself. Now this is handy in some cases, but in my case I just want to copy the exact formula without auto update. Is this possible? If yes, could you tell me how? Thanks Rgds Will |
| [2017-07-21 14:00:28] |
| |
|
This is the proper formula to use: AND (9 < ID2.SG1@$3, ID2.SG1@$3 < 19) No need to use IF Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: