Date/Time: Wed, 29 Jun 2022 22:35:22 +0000
Spreadsheet Functions IF errors
View Count: 776
|yoytu - Posts: 59|
Format: IF(Condition, TrueValue, FalseValue)a simple =if(A1>A2,1,0) give invalid formula
Evaluates the condition and returns the TrueValue if the condition evaluates to TRUE or the FalseValue if it evaluates to FALSE.
|vegasfoster - Posts: 444|
That should work, did you figure it out? If not, can you post a pic?
Sierra Chart Engineering - Posts: 103520
Rather than the comma delimiter you probably need to use a semicolon delimiter based upon your region.
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:
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: