Support Board
Date/Time: Sat, 01 Feb 2025 01:51:09 +0000
[User Discussion] - Help with formula Spreadsheet
View Count: 694
| [2019-06-20 06:48:56] |
| User14686603 - Posts: 14 |
|
I deal with Spreadsheet, I can’t write the formula correctly, constantly gives an error: i need the iff operator to be true when the value is in the range from 500 to 1000 My formula: =IF(AND(ID4.SG1@3>500,ID4.SG1@3<1000)),1,0 ,but gives an error: SYNTAX ERROR Please help figure out |
| [2019-06-20 13:09:00] |
| Sawtooth - Posts: 4164 |
|
Try this: =IF(AND(ID4.SG1@3>500,ID4.SG1@3<1000),1,0) However, when the result is boolean (true/false), you don't need to use the IF function: =AND(ID4.SG1@3>500,ID4.SG1@3<1000) |
To post a message in this thread, you need to log in with your Sierra Chart account: