Support Board

Date/Time: Wed, 17 Sep 2025 00:43:24 +0000

Post From: Help with formula Spreadsheet

[2019-06-20 13:09:00] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4263
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)