The Excel TRUE function simply returns the logical value TRUE. It takes no arguments and exists mainly for compatibility with other spreadsheet programs — typing the bare word TRUE into a formula or cell does exactly the same thing. The genuinely useful knowledge on this page is what TRUE is: a logical value that quietly becomes 1 the moment you do math with it, which unlocks counting tricks like --(test) and SUMPRODUCT conditions.
=TRUE+TRUE is 2, and =--(B2>100) turns a test into 1 or 0.
Syntax
| Argument | Description | |
|---|---|---|
| none | TRUE() takes no arguments. The empty parentheses are required if you use the function form. |
Available in: every version of Excel. Microsoft keeps TRUE() around for compatibility with other spreadsheet applications; in everyday work, type the literal TRUE (no parentheses) and Excel recognizes it as the logical value automatically.
TRUE() vs typing TRUE
Type TRUE in a cell and Excel stores the logical value TRUE — centered automatically, uppercase, not text. Use it in formulas the same way:
One caution in the other direction: if you want the text “TRUE” rather than the logical value, wrap it in quotes — ="TRUE". The two look identical in a cell but behave differently in comparisons and math.
Try it: boolean arithmetic playground
Set a threshold and watch each test become TRUE/FALSE, then 1/0 under the double minus, then a count under SUM. Values in A2:A6 are fixed: 40, 85, 120, 65, 150.
Booleans as 1 and 0: the –– trick
The moment a logical value meets arithmetic, Excel converts it: TRUE → 1, FALSE → 0. That single fact powers a whole family of formulas.
| A | B | C | |
|---|---|---|---|
| 1 | Formula | Result | Why |
| 2 | =TRUE() | TRUE | same as typing TRUE |
| 3 | =TRUE()+TRUE() | 2 | math coerces TRUE to 1 |
| 4 | =--(5>3) | 1 | double minus makes it a number |
| 5 | =TRUE()*10 | 10 | 1 × 10 |
The double minus -- is the idiomatic way to force the conversion without changing the value: the first minus turns TRUE into -1, the second flips it back to 1.
Multiplying tests works the same way and reads like AND: (A2:A100="West") * (B2:B100>500) is 1 only where both are TRUE. SUMPRODUCT happily consumes these arrays in every Excel version — no special array-entry needed.
Counterpart: everything here mirrors on the FALSE page — FALSE coerces to 0, which is exactly why untrue tests drop out of SUMPRODUCT totals.
Pitfalls to avoid
Pitfall: text “TRUE” is not the value TRUE. ="TRUE" stores a text string. It fails =A2=TRUE comparisons and errors in math. If imported data arrives as text booleans, convert with =A2="TRUE".
Pitfall: TRUE doesn’t equal 1 in comparisons. Coercion happens in arithmetic, not equality: =TRUE=1 returns FALSE because logicals and numbers are different types. =TRUE+0=1 returns TRUE.
Pitfall: COUNTIF counts logicals literally. =COUNTIF(A2:A10, TRUE) counts cells holding the logical value TRUE, not cells holding 1 — another consequence of the type distinction.
#NAME? — a typo like TRU or TRUE) without the opening parenthesis. The function itself exists everywhere, so a name error on this page is almost always a misspelling.
Practice workbook
Frequently asked questions
What's the difference between TRUE and TRUE() in Excel?
TRUE is the normal style.Why does TRUE turn into 1 in my formulas?
=TRUE+TRUE is 2 and =(B2>100)*50 is 50 or 0. Comparisons don’t coerce — =TRUE=1 is FALSE.What does the double minus (--) do?
=SUMPRODUCT(--(A2:A100>500)) counts how many tests pass.How do I count TRUE values in a range?
=COUNTIF(A2:A100, TRUE). If you're counting passing tests computed on the fly: =SUMPRODUCT(--(B2:B100>0)).Why does my imported TRUE behave strangely?
=A2="TRUE", which returns a real logical, or multiply-proof it with =--(A2="TRUE") for 1/0.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class