TRUE

Formulas / TRUE
Verify the logical value TRUE.
=TRUE()
  • arg_1 - required argument
  • arg_2 - [OPTIONAL] argument

Examples

  • =IF(A1>90,TRUE())

    The TRUE function returns the value TRUE. This is useful when you need to return a boolean value in an IF statement. For example, this will return TRUE if the value in A1 is greater than 90.

  • =IF(A1>=65,TRUE())

    The TRUE function can also be used in conjunction with other comparative operators. For example, this will return TRUE if the value in A1 is greater than or equal to 65.

  • =TRUE()

    The TRUE function can also be used on its own to return the value TRUE. For example, this will always return the value TRUE.

  • =A1>90

    The TRUE function can also be used without an IF statement. For example, this will return TRUE if the value in A1 is greater than 90.


Summary

The TRUE function is used to return the logical value TRUE if a condition is met. It can also be entered directly into cells and formulas without a function.

  • The TRUE function is a compatibility function that returns true when used in logical expressions.

Frequently Asked Questions

What is the syntax of the TRUE function?
The syntax of the TRUE function is TRUE().
What does the TRUE function do?
The TRUE function returns TRUE if the argument is TRUE.
What type of argument should be passed to the TRUE function?
The argument passed to the TRUE function should be a logical value.
What are some examples of arguments that can be passed to the TRUE function?
  • TRUE
  • FALSE
  • 1
  • 0
What is the output of the TRUE function if the argument is TRUE?
The output of the TRUE function is TRUE if the argument is TRUE.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV