Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 19:40:10 +0000



Post From: Help with formula Spreadsheet

[2019-06-20 13:09:00]
Sawtooth - Posts: 3980
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)