Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more
The NOT function in Google Sheets is a logical function that reverses the logical value of an expression. It returns the opposite of a logical value.
When you use the NOT function, you provide a logical expression as an argument. If the expression is TRUE, the function returns FALSE. If the expression is FALSE, the function returns TRUE.
For example, the formula =NOT(TRUE) returns FALSE, and the formula =NOT(FALSE) returns TRUE.
So, if you want to invert the result of a logical expression in Google Sheets, you can use the NOT function.