Support Board

Date/Time: Sun, 19 May 2024 12:36:29 +0000

Post From: How to negate a condition

[2014-08-20 20:48:45] Link To Thread - Link To Post [Go To First Post]
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.