When you are building complex formulas in Microsoft Excel, you are almost always dealing with Boolean logic. A Boolean value represents one of two absolute states: it is either TRUE or it is FALSE.
While you normally generate these values by comparing things (e.g., asking Excel =A1>10 will automatically output the word TRUE or FALSE), Excel also has dedicated functions that simply generate these literal values on demand: the TRUE() and FALSE() functions.
The Syntax
These are two of the simplest functions in all of Excel. They require absolutely no arguments inside the parentheses.
=TRUE()=FALSE()
If you type =TRUE() into an empty cell and hit Enter, the cell will just display the word TRUE.
Why Would You Use Them?
On their own, typing =TRUE() seems pointless (you could just type the word “TRUE” on your keyboard). However, these functions are designed to ensure data consistency when nested inside larger, complex logical formulas, like IF statements.
Example 1: Setting a Status Flag with an IF Statement
Imagine you are reviewing expense reports. If the expense in Cell A2 is greater than $500, you want to flag it for manager approval. If it is less than $500, it does not need approval.
You could write: =IF(A2>500, "Needs Approval", "Okay")
However, if you are building a database where another system is going to read this column to trigger an automated workflow, text strings like “Needs Approval” can cause errors. Computers prefer strict boolean logic.
Instead, you can use the TRUE and FALSE functions as the outputs:
=IF(A2>500, TRUE(), FALSE())
If the expense is $600, the cell outputs a programmatic TRUE. If the expense is $40, it outputs FALSE. This ensures your spreadsheet outputs pure, mathematically recognized logical values rather than simple text.
Example 2: Hardcoding a VLOOKUP
When you write a VLOOKUP formula, the final argument asks if you want an approximate match (TRUE) or an exact match (FALSE).
While most people just type =VLOOKUP(A2, B:C, 2, FALSE), typing =VLOOKUP(A2, B:C, 2, FALSE()) explicitly forces Excel to use the mathematical boolean value, completely preventing any accidental text-formatting errors if your spreadsheet is converted or exported to another software platform like Google Sheets.
Best Practices and Modern Excel
In modern versions of Excel (2016 and newer), simply typing the word TRUE or FALSE without the parentheses is usually sufficient, as Excel will automatically recognize the words as logical values and center them in the cell.
However, using the explicit TRUE() and FALSE() functions is considered a best practice for complex software integrations and when writing advanced VBA (Visual Basic for Applications) scripts to ensure there is zero ambiguity about your data type.