How to Use the TRUE Function in Excel
Today, we’ll explore the extremely helpful logical function in Excel and Google Sheets named TRUE.
Overview
The TRUE function straightforwardly returns the logical value TRUE. It requires no arguments, consistently providing the TRUE value.
Syntax
The syntax for the TRUE function is straightforward:
=TRUE()Examples
Let’s delve into a few practical applications of the TRUE function:
Example 1: Using TRUE in a Formula
In this illustration, we incorporate the TRUE function into a basic formula. Consider a scenario where we need to verify if cell A1 is not empty and return TRUE if so:
| Data | Formula | Result |
|---|---|---|
| 42 | =IF(A1<>"", TRUE(), FALSE()) |
TRUE |
Example 2: Using TRUE in Conditional Formatting
The TRUE function can also be utilized in Conditional Formatting to emphasize cells that satisfy specific criteria. For instance, to highlight cells containing a value over 50:
- Select the desired range of cells for formatting.
- Navigate to Format then Conditional formatting.
- Set “Greater than” as the formatting condition.
- Input the formula
=A1>50and choose a formatting style.
These examples illustrate just a couple of ways the TRUE function can be utilized in Excel and Google Sheets to conduct logical operations and enhance the dynamism of your spreadsheets.
More information: https://support.microsoft.com/en-us/office/true-function-7652c6e3-8987-48d0-97cd-ef223246b3fb