Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 10 May 2024 09:44:26 +0000
Post From: Spreadsheet study - If statement - why cell references required?
| [2020-05-15 16:58:09] |
| User695518 - Posts: 50 |
|
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! |