Google Sheets-funktion

NOT

Reverses the logical value of its argument.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

logicalobligatorisktA value or expression that can be evaluated to TRUE or FALSE.

Exempel

=NOT(TRUE)

Resultat: FALSE

Returns FALSE because the input is TRUE.

=NOT(10>20)

Resultat: TRUE

The expression 10>20 is FALSE, so NOT reverses it to TRUE.

Vanliga frågor

What happens if the argument is a number?

Excel treats 0 as FALSE and any non-zero number as TRUE.

Relaterade funktioner

AND OR IF