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.