Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 08:23:21 +0000



Post From: Syntax / Formula Help!

[2019-01-04 17:56:33]
Sawtooth - Posts: 4000
You can make it clearer if you eliminate the intermediate ANDs and their parentheses, and put each condition on its own line:

=AND(
ID6.SG1 - ID1.SG1 >= 1.5,
ID4.SG1 - ID1.SG1 >= 1,
ID4.SG1 > ID3.SG1,
ID1.SG1 > ID2.SG1,
ID2.SG1 - ID3.SG1 >= 0.25,
ID4.SG1 - SG1 < 1,
ID4.SG1 - SG1 > 0)