Reverses the logical value of its argument.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
NOT(logical)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)Ergebnis: FALSE
Returns FALSE because the input is TRUE.
=NOT(10>20)Ergebnis: TRUE
The expression 10>20 is FALSE, so NOT reverses it to TRUE.
Excel treats 0 as FALSE and any non-zero number as TRUE.