Support Board
Date/Time: Fri, 24 Jan 2025 06:56:16 +0000
Post From: Syntax / Formula Help!
[2019-01-04 17:39:07] |
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. |