Support Board
Date/Time: Wed, 27 Nov 2024 11:46:16 +0000
Post From: How to negate a condition
| [2014-08-20 20:48:45] |
| User28286 - Posts: 24 |
|
I just tried Excel's NOT operator, and it seems to work. The syntax is: NOT( logical_value ), and it simply returns the opposite of 'logical_value'. I can tell it's very useful in many cases where you want to define conditions where eg. "A and B and C, but NOT D". I recommend for you to verify it and add into the operator list in "Alert Condition Formula Format" in SC guide.
|