Article updated on February 16, 2018

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

TRUE returns FALSE and FALSE returns TRUE.

Formula in cell C3:


Excel Function Syntax



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


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