Menu
EXCEL NOT FUNCTION
Excel NOT Function Introduction
This function reverses the value of its inputs and returns a logical value in the opposite direction. In other words, if any of the formulae evaluates to TRUE and you call this function, you will receive FALSE; if the formula evaluates to TRUE, you will get TRUE.
Description of Excel NOT Function
Syntax:
=NOT (logical)
Parameter list:
A value or logical expression that may be assessed as TRUE or FALSE is said to as logical.
Step By Step Guide of NOT Function
- Reversing the operation of another function is a frequent example. If cell A1 is blank, for example, the formula =ISBLANK(B1) will provide TRUE.
- NOT can be used to convert this result to FALSE in the following way:
=NOT(ISBLANK(A1)) - In other words, by adding NOT, you may make a formula that acts like ISNOTBLANK, which isn’t available in Excel.
Key Points
- Because it reversed the logical value, =NOT(FALSE) will return TRUE.
- Because the sum of 4+4 equals 8 and is true, =NOT(4+4=8) returns the value FALSE, reversing the logical value to FALSE.
- =NOT(4+3=8) returns TRUE because the total of 4+3 is not 8 and hence false, reversing the logical result to TRUE.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
