Free Online Tutorials on Spreadsheets

TRUE function in Excel


The TRUE function is used for compatibility with other spreadsheets. It returns the logical value TRUE and often used when you want the value TRUE based on a condition.


Suppose, you want the value TRUE, if value in cell A1 is smaller than 9.

Result. The value in cell A1 is ‘1’ which is smaller than 9. So the function returns the value TRUE.

For more example, visit Microsoft Office official website.



The function has no argument.

Related Functions

The TRUE function is a Logical function and has the following related functions:

AND function tests a number of logical conditions set by a user.

FALSE function returns the Boolean value False.

IF function checks whether a specified condition is met or not.

OR function tests multiple logical conditions at the same time.

Copyright © 2016 - 2019 | All Rights Reserved