Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 15:34:21 +0000



[User Discussion] - Help with formula Spreadsheet

View Count: 616

[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: 3952
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:

Login

Login Page - Create Account