Reverses the logical value of its argument.
Söz dizimi
NOT(logical)Bağımsız değişkenler
logicalzorunlu
A value or expression that can be evaluated to TRUE or FALSE.
The NOT function returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE. It is typically used to invert the result of another logical test within a formula.
=NOT(TRUE)→FALSEReturns FALSE because the input is TRUE.
=NOT(10>20)→TRUEThe expression 10>20 is FALSE, so NOT reverses it to TRUE.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =NOT(logical) and replace 'logical' with your condition or cell reference.
Press Enter
Press Enter to calculate the inverted logical value.
Excel treats 0 as FALSE and any non-zero number as TRUE.