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) |