Search

# Excel TRUE Function | Formula Examples + FREE Video

## Excel TRUE Function (Example + 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.

=TRUE()

### Input Arguments

• It does not take any input arguments.

• 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 – Video Tutorial

Related Excel Functions:

FREE EXCEL BOOK

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

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.

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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