Author: Oscar Cronquist Article last 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.