NOT

The NOT function returns TRUE if the argument is FALSE and FALSE if the argument is TRUE.

Syntax

not(logical_test)

Arguments

logical_test – The condition to be evaluated

Return value

Either True or False

Example

if(not(Region == "West"), 50, 25)

Will return 50 if the region is not West; otherwise returns 25

Excel equivalent

NOT