| Syntax |
| =NOT(logical) |
| Purpose / Description |
| Returns TRUE if the value passed is FALSE or zero. It returns FALSE if the value passed is TRUE or non-zero. Can be used to specify c condition not met. |
| Arguments |
| Name |
Type |
Description |
| logical |
any |
A constant, constant array, reference or nested expression that returns a value to be checked together with any other arguments. If a range reference or nested expression is used, it may return more than one value in each argument. Text strings are ignored. |
| Return Values |
| Type |
Specific Value |
Description |
| logical |
TRUE |
If the value passed is FALSE or zero. |
| logical |
FALSE |
If the value is TRUE or non-zero |
| error |
#VALUE! |
If the value passed is a text string. |
| error |
#REF! |
If a range reference that spans worksheets is passed. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
This function does not accept range references that span worksheets. |
| Note: |
This function can be used in an array formula to do row-by-row or column-by-column evaluation. |
| Examples: |
Open / download sample workbook: AND, OR, XOR, NOT.xlsx |
| |