TRUE Function in MS Excel: Syntax, Arguments & Examples

What is the TRUE Function in MS Excel?

This is a logical function in MS Excel. That is why it does not need any argument to operate. It is also used in combination with many other conditional functions, for example, the IF function,

Purpose of TRUE Function in Excel

This is used to return a TRUE value as the result. This is used as the Boolean logical value TRUE. It is used in a condition where you want the returned value to be TRUE.

Syntax of TRUE Function

The syntax of the TRUE function is written below.



There is no argument in the TRUE function.


= IF (A2>0, TRUE ())

In the above example, the TRUE function is used in combination with the IF function. If the condition in the IF function is TRUE, THEN the function will return the value TRUE.

Scroll to top