Excel TRUE Function | Formula Examples + FREE Video

When to use Excel TRUE Function

TRUE function returns the logical value TRUE. It does not take any input arguments.

What it Returns

It returns the logical value TRUE.



Input Arguments

  • It does not take any input arguments.

Additional Notes

  • TRUE function is best used when you are evaluating a condition, and if is TRUE, you simply want to get the TRUE value in the cell. For example:
    • =IF(AND(A1>0,A1<100),TRUE(),”Reject”)
      In this example, if the condition is not met, it simply returns TRUE as the result.
  • If you type TRUE (without parenthesis) in a formula or in a cell, excel automatically takes it as the TRUE logical value.
    • TRUE and TRUE() both would return the same value.
  • In terms of value, a FALSE is a 0 and a TRUE is a 1. These can be used in calculations.
    • For example: =TRUE+TRUE would be 2 and =FALSE+TRUE would be 1
  • According to Microsoft Help, Excel TRUE function is provided primarily for compatibility with other spreadsheet programs.

Add a Comment

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