FALSE()
Syntax. FALSE()
Definition. This function returns the logical value (Boolean value) FALSE.
Arguments. None
Background. This function is seldom used, because you can just enter the word false. Excel interprets the result returned by the function as a logical value (in this case, FALSE). The interpretation forced by numeric operations is the number value 0. You can check this by entering the formula =3+FALSE in a cell.
However, if you compare two cells, and one cell contains FALSE and the other cell 0, the result is FALSE.
You can enter false (which is not case-sensitive) directly in a worksheet or formula. Excel recognizes this word as the logical value FALSE and formats the cell accordingly. To avoid this, do one of the following:
Format the ...
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.
