Author: Oscar Cronquist Article last updated on May 18, 2022

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.