Support Board

Date/Time: Wed, 24 Dec 2025 16:53:41 +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: 4300
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)