TRUE Function in Excel Tutorial

Excel Tutorial

Introduction

The TRUE function in Excel returns the logical value TRUE. It is useful when working with logical conditions, checking data, and creating formulas that require a TRUE result. Unlike many Excel functions, TRUE does not require any arguments.

In this tutorial, you will learn how to use the TRUE function with practical examples based on employee records, sales data, and business information.

What Is the TRUE Function in Excel?

The TRUE function returns the logical value TRUE.

It does not need any input or arguments. When entered into a cell, Excel displays TRUE as its result.

TRUE Function Syntax

=TRUE()

Arguments:

The TRUE function does not require any arguments. The empty parentheses are part of its syntax.

Practical Examples of TRUE Function in Excel

Question 1: Return a TRUE Value in a Cell

Problem Statement: A company wants to mark a particular status as TRUE in its employee record.

Data:

EmployeeStatus
Rahul
Priya
Amit
Neha

Excel Formula:

=TRUE()

Expected Result:

EmployeeStatus
RahulTRUE
PriyaTRUE
AmitTRUE
NehaTRUE

Explanation: Enter the formula in B2 and copy it down to B5. Each cell returns the logical value TRUE.

Concept Covered: Returning a logical TRUE value.

Question 2: Use TRUE to Mark a Product as Available

Problem Statement: A store wants to mark products as available in its inventory record.

Data:

ProductAvailability
Laptop
Keyboard
Mouse
Monitor

Excel Formula:

=TRUE()

Expected Result:

ProductAvailability
LaptopTRUE
KeyboardTRUE
MouseTRUE
MonitorTRUE

Explanation: Enter the TRUE formula in B2 and copy it down. Each product receives a TRUE status.

Concept Covered: Using TRUE as a logical availability status.

Question 3: Mark Completed Training Records

Problem Statement: A training department wants to mark employees as having completed a training program.

Data:

EmployeeTraining Completed
Rahul
Priya
Amit
Neha

Excel Formula:

=TRUE()

Expected Result:

EmployeeTraining Completed
RahulTRUE
PriyaTRUE
AmitTRUE
NehaTRUE

Explanation: Enter the formula in B2 and copy it down. The result marks every listed training record as TRUE.

Concept Covered: Representing completion status with a logical value.

Question 4: Compare TRUE with the Logical Value

Problem Statement: A company wants to check whether a cell contains the logical value TRUE.

Data:

EmployeeVerification Status
RahulTRUE
PriyaFALSE
AmitTRUE
NehaFALSE

Excel Formula:

=A2=TRUE()

Expected Result:

EmployeeVerification StatusResult
RahulTRUETRUE
PriyaFALSEFALSE
AmitTRUETRUE
NehaFALSEFALSE

Explanation: Enter the formula in C2 and copy it down. The comparison returns TRUE when the value in column B is the logical value TRUE. Otherwise, it returns FALSE.

Concept Covered: Comparing a cell with the logical TRUE value.

Question 5: Convert TRUE into Its Numeric Equivalent

Problem Statement: A company wants to understand the numeric value associated with the logical TRUE result.

Data:

EmployeeLogical Value
RahulTRUE
PriyaTRUE
AmitTRUE
NehaTRUE

Excel Formula:

=TRUE()*1

Expected Result:

EmployeeLogical ValueNumeric Result
RahulTRUE1
PriyaTRUE1
AmitTRUE1
NehaTRUE1

Explanation: Excel treats the logical value TRUE as 1 in this arithmetic calculation. Multiplying TRUE by 1 returns the numeric value 1.

Concept Covered: Understanding the numeric equivalent of TRUE.

Important Things to Remember

  • TRUE is an Excel logical function.
  • Its syntax is =TRUE().
  • It does not require any arguments.
  • It returns the logical value TRUE, not text.
  • Excel treats TRUE as 1 in arithmetic calculations.
  • The logical value TRUE is different from the text "TRUE".
  • TRUE can be entered directly in a cell as a logical value.

Student Practice Tasks

Try these tasks using the TRUE function.

  1. Enter TRUE for all employees in a training completion record.
  2. Mark all products as available in an inventory sheet.
  3. Create a TRUE status for all approved customer records.
  4. Compare logical TRUE values in a verification column.
  5. Convert logical TRUE values into their numeric equivalent.

Final Student Challenge: Build an Employee Verification Report

A company wants to create a simple employee verification report.

Given Data:

EmployeeVerification Status
Rahul
Priya
Amit
Neha
Karan

Your Task:

  • Use the TRUE function to fill the verification status.
  • Apply the formula to all five employees.
  • Check that every employee receives the logical value TRUE.

Expected Result:

EmployeeVerification Status
RahulTRUE
PriyaTRUE
AmitTRUE
NehaTRUE
KaranTRUE

Key Takeaways

  • TRUE returns the logical value TRUE.
  • Its syntax is =TRUE().
  • It does not require any arguments.
  • TRUE is different from text containing the word TRUE.
  • Excel treats TRUE as 1 in arithmetic calculations.

Frequently Asked Questions (FAQs)

1. What is the TRUE function in Excel?

The TRUE function returns the logical value TRUE in a worksheet cell.

2. What is the syntax of the TRUE function?

=TRUE()

3. Does the TRUE function require arguments?

No. The TRUE function does not require any arguments.

4. What does the TRUE function return?

It returns the logical value TRUE.

5. What is the numeric value of TRUE in Excel?

Excel treats the logical value TRUE as 1 in arithmetic calculations.

6. Is TRUE a text value in Excel?

No. TRUE is a logical value. The text "TRUE" is a separate text value.

7. Can I enter TRUE directly into an Excel cell?

Yes. You can type TRUE into a cell without using the formula. Excel recognizes it as a logical value.

8. Which Excel versions support the TRUE function?

The TRUE function is supported in modern Excel versions, including Excel 2016, 2019, 2021, 2024, and Microsoft 365.