EXCEL TRUE FUNCTION

The logical value TRUE is generated by this function.

Syntax:

=TRUE ()

There are no parameters to the TRUE function.

Step By Step Guide of TRUE Function

If you wish to insert TRUE or offer TRUE as a result in a calculation, simply type TRUE into a cell or formula, and Excel will read it as TRUE. These formulae, for example, are functionally identical:
=IF(A10, TRUE())

  • It’s also worth noting that logical expressions create TRUE and FALSE outcomes on their own.
    For example, if the value of cell B7 is 110, the logical value TRUE will be returned by =B7>90.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now