Article updated on April 19, 2018

The NOT function returns the boolean opposite to the given argument.

TRUE returns FALSE and FALSE returns TRUE.

Formula in cell C3:

=NOT(B3)

Excel Function Syntax

NOT(logical)

Arguments

logical Required. A boolean value or it's equivalent. TRUE = 1 and FALSE equals 0.

Comments

Note, the NOT function returns TRUE for a blank cell, see cell B8 and C8.