Login Page - Create Account

Support Board

Date/Time: Wed, 29 Jun 2022 22:35:22 +0000

Spreadsheet Functions IF errors

View Count: 776

[2014-01-25 17:31:23]
yoytu - Posts: 59
Format: IF(Condition, TrueValue, FalseValue)

Evaluates the condition and returns the TrueValue if the condition evaluates to TRUE or the FalseValue if it evaluates to FALSE.
a simple =if(A1>A2,1,0) give invalid formula
[2014-01-26 21:39:18]
vegasfoster - Posts: 444
That should work, did you figure it out? If not, can you post a pic?
[2014-01-26 21:48:25]
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:


Login Page - Create Account