Support Board
Date/Time: Mon, 25 Nov 2024 09:29:29 +0000
Spreadsheet Functions IF errors
View Count: 1210
| [2014-01-25 17:31:23] |
| 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. |
| [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] |
| |
|
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: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation 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: