TRUE function in Excel

What is TRUE function in Excel?

The TRUE function is one of the Logical functions of Excel.

It returns the logical value true.

We can find this function in the Logical of insert function Tab.

How to use TRUE function in excel

1. Click on an empty cell (like F5 )

 an empty cell

2. Click on the fx icon (or press shift+F3)

 fx icon excel

3. In the insert function tab you will see all functions

insert function tab excel

4. Select Logical category

5. Select TRUE function

6. Then select ok

7. This function takes no arguments

8. You will see the results in formula result section

How to use TRUE function in excel

Examples of TRUE function in excel

Python code for TRUE function

def myFunction() :
  return True
print(myFunction())

What is the purpose of TRUE function?

What is the Return value  of TRUE function?

How many arguments does TRUE function have?

This function has just 1 Argument.

The argument of ABS function is number.

The argument of ABS function is required and not optional.

Which version of excel supports TRUE function?

This function is available for all excel versions (2003-2019)

Errors in TRUE function

TRUE related functions

Leave a Reply

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