Support Board

Date/Time: Wed, 08 May 2024 16:49:10 +0000

[Programming Help] - Can someone identify why I'm getting a #syntax error here?

[2019-02-27 14:32:25] #1 [Go To First Post]
User917679 - Posts: 76
Don't know whats wrong computationally.. (spreadsheet input is to cell J26) = (((J48/J49 * J$6$ - J$6$) * 8.6 - (J48/J49 * J$6$ - J$6$) * 8.6 * 0.15) + J$6$ + J$6$ * 9) * 0.1 Date Time Of Last Edit: 2019-02-27 14:33:30

[2019-02-27 16:22:03] #2 [Go To First Post]
Sawtooth - Posts: 3993
You have the absolute value symbol '$' in the wrong place: = (((J48/J49 * $J$6 - $J$6) * 8.6 - (J48/J49 * $J$6 - $J$6) * 8.6 * 0.15) + $J$6 + $J$6 * 9) * 0.1

To post a message in this thread, you need to log in with your Sierra Chart account: