NOT FUNCTION

NOT FUNCTION

This article describes the formula syntax and usage of the NOT function in MS Excel.

Description

Reverses the value of the argument to make sure that the value is not equal to any particular value. It returns TRUE if the argument is False and returns FALSE the given condition or argument is True.

Formula SYNTAX

=NOT(condition) The NOT Function has the following arguments: ·         Condition = Required. A Value or expression that can be evaluated to either TRUE or FALSE.

  

EXAMPLE 1
=NOT(5+2=7)	Return a value FALSE. The condition that evaluates to True is reversed.
=NOT(18>20)	Returns a value TRUE. The argument is reversed.