Support Board

Date/Time: Sat, 18 May 2024 04:04:56 +0000

Post From: Syntax / Formula Help!

[2019-01-04 17:39:07] Link To Thread - Link To Post [Go To First Post]
stocknerd1 - Posts: 10
Hello, I have a few conditions that i want to all be true and alert and I am getting a syntax error. Here's what I have =AND((ID6.SG1 - ID1.SG1) >= 1.5, (ID4.SG1 - ID1.SG1) >= 1), AND(ID4.SG1 > ID3.SG1, ID1.SG1 > ID2.SG1), AND((ID2.SG1 - ID3.SG1) >= 0.25, (ID4.SG1 - SG1) < 1), AND((ID4.SG1 - SG1) > 0) I've kind of tested the syntax by wrapping the whole thing in an OR() function from reading the documentation and it works fine w/ no syntax error but I am wanting all of the conditions to be True. What is the syntax to string these AND() functions together or how could I accomplish this? Thank you in advance for your time.