Excel TRUE Function | Formula Examples + FREE Video

Excel TRUE Function (Example + Video)

Excel TRUE Function

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.

Excel TRUE Function – Live Example

Excel TRUE Function – Video Tutorial

Related Excel Functions:

Excel Ebook Subscribe


Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment