Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last row in numeric data in Excel
  • Left Lookup in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • Vlookup Examples in Excel
  • How to get relative column numbers in a range in Excel

Data Analysis Examples

  • How to create a Histogram in Excel
  • Working With Tables in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Excel Frequency Function Example
  • How To Filter Data in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • Prevent invalid data entering in specific cells
  • Excel Data validation unique values only
  • Excel Data validation allow weekday only
  • Excel Data validation whole percentage only

TRUE function: Description, Usage, Syntax, Examples and Explanation

by

What is TRUE function in Excel?

TRUE function is one of the Logical functions in Microsoft Excel that returns the logical value TRUE. You can use this function when you want to return the value TRUE based on a condition. For example:

Worked Example:   How to strip numeric characters from cell in Excel

=IF(A1=1,TRUE())

You can also enter the value TRUE directly into cells and formulas without using this function. For example:

Worked Example:   How to return TRUE when all cells in range are blank in Excel

=IF(A1=1,TRUE)

If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.

Worked Example:   How to retrieve first match between two ranges in Excel

Syntax of TRUE function

TRUE()

The TRUE function syntax has no arguments.

You can visit:

  • How to use Excel TRUE Function
  • How to use Excel FALSE Function

Post navigation

Previous Post:

XOR function: Description, Usage, Syntax, Examples and Explanation

Next Post:

IFNA function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Split dimensions into two parts in Excel Worksheet
  • How to strip numeric characters from cell in Excel
  • Split text and numbers in Excel
  • How to convert numbers to text using TEXT function in Excel
  • How to extract domain name from URL in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Get date from day number in Excel
  • Convert Excel time to decimal hours in Excel
  • Custom weekday abbreviation in Excel
  • Display Days in month in Excel
  • Calculate cumulative loan interest in Excel
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
  • How to Calculate Tax Rates in Excel
  • How to calculate principal for given period in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles