Introduction
Returns true when the input is false, and false otherwise.
| FORMULA | NOT(boolean) |
| EXAMPLE FORMULA | NOT(temp_col > 80) |
| EXAMPLE INPUT | 100 |
| EXAMPLE OUTPUT | FALSE |
Sample Usage
| Valid Examples | Invalid Examples |
NOT(Text Column="Kiwi") | NOT(Date="2014-03-12 00:00:00.000", TRUE) |
| NOT(Number Column > 12) | AND(Text Column="Kiwi", Text Column="Apple") Shows all values as false. |
| NOT(Number as Text Data Type >"10", Number as Text Data Type <"600") |
Notes
- Dates cannot be applied to NOT formula,
- When using the “text” data type, be sure to use quotes.
See Also
AND
IF
OR
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article