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