Support Board
Date/Time: Fri, 10 Jan 2025 21:04:38 +0000
Post From: Combing AND,OR functions in alert
[2016-09-27 12:56:09] |
jackw - Posts: 57 |
=AND( AND (ID21.SG1 < ID21.SG2, ID11.SG1[0] <= ID11.SG1[-5], ID11.SG1[-5] <= ID11.SG1[-10]) , OR (ID20.SG1[0] <= ID20.SG1[-5], ID20.SG2[0] < ID20.SG2[-1]) ) This will return true if all the conditions in your AND statement are true, and one of the conditions in your OR statement is true. |