Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 29 Apr 2024 06:37:32 +0000

How to Post a Message for Support

Post From: Help with formula Spreadsheet

[2019-06-20 06:48:56]
[Go To First Post]
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