Support Board
Date/Time: Thu, 06 Feb 2025 23:49:12 +0000
[User Discussion] - Spreadsheet study - If statement - why cell references required?
View Count: 532
| [2020-05-15 16:58:09] |
| User695518 - Posts: 53 |
|
Hello, I am using a spreadsheet study in SC 2092. Why can I not use: =IF(FRACTIME(J41) > TIMEVALUE("06:29:59"),ID11.SG1@04,ID11.SG1@03) Instead I have to use: =IF(FRACTIME(J41) > TIMEVALUE("06:29:59"),AO4,AO3) SYNTAX! I much prefer to use study references, as opposed to cell references, as cell references can change. Am I doing something wrong? Thanks! |
| [2020-05-15 17:04:17] |
| Sawtooth - Posts: 4173 |
|
=IF(FRACTIME(J41) > TIMEVALUE("06:29:59"),ID11.SG1@04,ID11.SG1@03) should be: =IF(FRACTIME(J41) > TIMEVALUE("06:29:59"),ID11.SG1@4,ID11.SG1@3) |
| [2020-05-15 17:25:05] |
| User695518 - Posts: 53 |
|
DOH! Thanks again Tom! You are awesome.
|
To post a message in this thread, you need to log in with your Sierra Chart account: