NOT()
Syntax. NOT(logical)
Definition. This function reverses the logical value of your argument. Use the NOT() function if you want to incorporate the logical opposite of an expression in a calculation.
Arguments
logical (required). A value or expression that can be evaluated to TRUE or FALSE
Background. If the logical argument is FALSE, the NOT() function returns TRUE. If the logical argument is TRUE, the NOT() function returns FALSE. In the example shown previously, for the FALSE() function, the formula
=(AND(MOD(MONTH(B13),3)=0,DAY(B13)>20)=TRUE)
checked whether the date fell at the end of a quarter, and
=(AND(MOD(MONTH(B13),3)=0,DAY(B13)>20)=FALSE)
checked for days that did not fall at the end of a quarter. You can shorten these conditions:
=(AND(MOD(MONTH(B16),3)=0,DAY(B16)>20)) ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
