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