Support Board
Date/Time: Fri, 07 Feb 2025 02:20:12 +0000
Post From: Spreadsheet study - If statement - why cell references required?
[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! |