Ravindra BagaleCourses & study guides Track your progress

Excel TRUE Function

By · Last updated:

Chala mitrano — today TRUE. The boolean constant — useful in tests and as VLOOKUP’s exact-match flag.

Fictional sample data for learning. Boolean flags in Pune dispatch and Berlin ops. Mixed ₹ and €.

Purpose

Return the logical value TRUE.

Return value

The logical value TRUE.

Syntax

TRUE()

Arguments

ArgumentRequired?Description
(none)—TRUE() takes no arguments.

Version

All Excel versions. LibreOffice too.

How to use — Why → What → How

Why: TRUE() writes an explicit boolean. Prefer it over 1/0 when teaching logic. Boolean flags in Pune dispatch and Berlin ops. Mixed ₹ and €. In Indian back offices and foreign sister teams, TRUE shows up on approval, SLA and fee sheets every week.

What: TRUE() returns the logical TRUE. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =TRUE().
  2. Use inside IF/AND/OR.
  3. For VLOOKUP exact match use FALSE().

Ravindra Bagale's Tip

Friends, after TRUE, find one IF/logic cell in a real workbook this week that this lesson improves.

Ravindra Bagale's Tip

Friends, sleep on TRUE; rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business rule in plain words before =TRUE.

Ravindra Bagale's Tip

Friends, after you finish TRUE, open yesterday’s real workbook and find one place this function would have saved ten minutes.

Ravindra Bagale's Tip

Friends, treat TRUE like a seatbelt on logic columns — use it before a manager asks why the flag is wrong.

Download practice file: practice-true.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Constant

Flag.

X
x
Formula: =TRUE()

Result: TRUE

What it means: Boolean true.

2) In IF

Force branch.

A
1
Formula: =IF(TRUE(),"Yes","No")

Result: Yes

What it means: Always Yes.

3) Compare

Checkbox style.

Done
TRUE
Formula: =A2=TRUE()

Result: TRUE

What it means: Equality to TRUE (ensure boolean/text match in class).

4) Pune ₹

Gate.

OK₹
TRUE100
Formula: =IF(A2="TRUE","Ship","Wait")

Result: Ship

What it means: Ship when true flag.

5) AND with TRUE

Identity.

T
Yes
Formula: =AND(A2="Yes",TRUE())

Result: TRUE

What it means: TRUE and TRUE path.

6) Berlin €

Legend.

Flag€
TRUE10
Formula: =TRUE()

Result: TRUE

What it means: Document boolean flags.

Common errors and fixes

#NAME? — Typo. Fix: Spell TRUE/FALSE.
Confused with text — "TRUE" as text. Fix: Use boolean not text.
1/0 mix — Inconsistent types. Fix: Stay with booleans in logic columns.

Notes and tips

  • Revisit TRUE errors after the quiz.
  • Build one example from memory.
  • Check types if results look wrong.
  • Teach a tip in Marathi or Hindi.
  • Keep currency consistent in one column (practice mixes ₹ $ £ €).
  • Drill: use TRUE() explicitly in a flag column from memory.
  • TRUE vs typed 1/0: booleans keep logic columns clear.
  • Fictional sample data only.
  • Print the TRUE revision card.
  • Ask juniors to predict before Enter.
  • Track your top mistake monthly.
  • Boolean flags in Pune dispatch and Berlin ops. Mixed ₹ and €.
  • Logical tests love TRIM and UPPER when text is messy.
  • Interview tip: explain the business rule before the formula.
  • When nesting, keep each IF on its own mental line — or switch to IFS/SWITCH.
  • Classroom drill: invent three brand-new formulas from your city without the page open.
  • Share one tip with a classmate — teaching locks the idea.
  • If a result looks wrong, check blanks vs zeros before rewriting logic.
  • Print the revision card for TRUE for one week of real worksheets.
  • When helping a junior, ask them to predict before Enter.
  • Share one tip with a classmate in Marathi or Hindi.
  • Keep currency symbols consistent inside a single report column.
  • When Excel versions differ, write a nested-IF fallback under IFS/SWITCH in a comment.
  • Logical tests love TRIM and UPPER when text is messy.
  • Interview tip: explain the business rule before the formula.

In real work

Drill: use TRUE() explicitly in a flag column from memory. Boolean flags in Pune dispatch and Berlin ops. Mixed ₹ and €. Classroom drill: write three brand-new TRUE formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known case before trusting a long chain of logical tests. Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

How it compares

TRUE vs typed 1/0: booleans keep logic columns clear.

Interview corner

What is TRUE()?
Boolean constant.
VLOOKUP link?
FALSE = exact match.
Text vs boolean?
Different.

IF, AND, OR, FALSE, TRUE

Practice tasks (10)

  1. Task 1. Enter =TRUE().
    Const.
  2. Task 2. Use in IF.
    IF.
  3. Task 3. Compare cell to constant.
    =
  4. Task 4. VLOOKUP FALSE demo.
    Exact.
  5. Task 5. Doc boolean column.
    Note.
  6. Task 6. Explain vs text.
    Interview.
  7. Task 7. AND/OR combo.
    Logic.
  8. Task 8. Fill flags.
    Fill.
  9. Task 9. Teach.
    Teach.
  10. Task 10. Bonus: data validation TRUE/FALSE.
    DV.

Quick quiz

Q1. TRUE() returns:
Q2. Arguments:
Q3. VLOOKUP exact:
Q4. Prefer over 1/0 when:
Q5. Text "TRUE" equals TRUE()?

Answers: Q1=Boolean TRUE, Q2=None, Q3=FALSE(), Q4=Teaching logic, Q5=Not the same type story (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: TRUE
TRUE revision card