Registered User Joined: 4/28/2016 Posts: 4
|
In order to consolidate the number of alerts, I would like to combine both of the expressions below into one formula using an OR.
For example, I would like to see alerts for either Formula # 1 OR Formula # 2 listed below.
Formula # 1
C1 >= O2 AND O3 >= O2 AND C3 >= C2 AND C1 > C2
Formula # 2
O3 >= O2 AND C3 >= C2 AND L2 <= L1 AND H2 >= H1
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Just combine them into one formula:
(C1 >= O2 AND O3 >= O2 AND C3 >= C2 AND C1 > C2) OR (O3 >= O2 AND C3 >= C2 AND L2 <= L1 AND H2 >= H1)
|
Registered User Joined: 4/28/2016 Posts: 4
|
Thanks StockGuy! I had a feeling it would be something like that, but I just wanted to get confirmation. Thanks for responding!
|