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:

Leave a Reply

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