Support Board

Date/Time: Mon, 14 Sep 2026 04:55:44 +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: 4352
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)