January 19, 2021

TRUE function in Excel

In this lesson we will learn how the TRUE function works in Excel. The TRUE function doesn’t take any input arguments and it returns the logical value TRUE.

=TRUE()

Let’s understand with a simple example. In the below table, the TRUE function is used in cell B1 evaluating the following condition.

=IF(AND(A2>0,A2<100),TRUE(),"Reject")

In this example, since the condition is met as the price value in cell A2 is 50 and 50>0 as well as 50<100. So it makes both arguments of AND function as 1. The AND function returns TRUE which in turn triggers TRUE() function inside IF and results TRUE in cell B2.

In the same example we just changed the price value as 150 in cell A2 and this will make one of the AND condition to return false which in turn makes the result of the AND function as 0 and in this case the TRUE() function is not triggered. So as per this IF condition, since the conditions are not met, it returned “Reject” as the result in cell B2.

Notes :
  • =TRUE and =TRUE() both would return the same logical value as TRUE.
  • In terms of value, a FALSE is a 0 and a TRUE is a 1 in Excel. 

For example: =FALSE+TRUE would be 1 and =TRUE+TRUE would be 2

You can also check here to understand how the TRUE function works in Google sheet.

You can also check here to understand how the FALSE function works in Google sheet.

You can also check here to understand how the FALSE function works in Excel.

Leave a Reply

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