Excel TRUE Function

This post will guide you how to use Excel TRUE function with syntax and examples in Microsoft excel.

Description

The Excel TRUE function return the logical value TRUE. And you can use the TRUE function when you want to return the TRUE value. For example, the formula: =IF(B1>5, TRUE()).

The TRUE function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.

The TRUE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the TRUE function is as below:

=TRUE ()

There are no parameters or arguments for the TRUE function.

Excel TRUE Function Examples

The below examples will show you how to use Excel TRUE Function to return the logical value TRUE

If you want to get the TRUE value, you just need to enter the word TRUE directly in to a cell or formula or you can enter the TRUE() function into a formula. And then it will be interpret as the logical value TRUE. Let’s see the below two formulas:

=IF(B1>1, TRUE())

or

=IF(B1>1, TRUE)

excel true examples1


Related Functions

  • Excel FALSE function
    The Excel FALSE function returns the logical value “FALSE”.The FALSE function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.The syntax of the FALSE function is as below:= FALSE ()…
Related Posts

Excel OR Function
Excel or examples2

This post will guide you how to use Excel OR function with syntax and examples in Microsoft excel. Description The Excel OR function used to test multiple conditions and returns TRUE if any of the conditions are TRUE. Otherwise, it ...

Excel NOT Function
excel not examples1

This post will guide you how to use Excel NOT function with syntax and examples in Microsoft excel. Description The Excel NOT function returns the opposite of a given logical or Boolean value. For example, if you supplied with the ...

Excel IF function check if the cell is blank or not-blank
Excel IF function check if the cell is blank or not-blank1

If you want to check the value in one cell if it is blank or empty cell, then you can use IF function in combination with ISBLANK function or logical operator (equal to) in excel. Excel IF function check if ...

Excel IF Function With Dates
Excel IF Function With Dates4

If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. You can use the IF function in ...

Excel IF function with text values
Excel IF function with Wildcards text value1

Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, ...

Excel IF Function With Numbers
Excel IF Function Examples For Numbers3

Normally, If you want to write an IF formula for numbers in combining with the  logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. ...

Excel IF formula with NOT logical function
Excel formula using IF NOT function3

This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical ...

Excel IF formula with operator : greater than,less than
The Generic IF formula with Greater than operato5

This post will guide you how to use if function with “greater than”,  “greater than or equal to”, ”less than” and “less than or equal to” logical operators in excel. Greater than, Greater than or equal to, Less than, less than ...

Excel IF formula with AND & OR logical functions
Excel IF formula with AND OR logical functions2

If you want to test the result of cells based on several sets of multiple test conditions, you can use the IF function with the AND and OR functions at a time. Assuming that you have the following test logic to check ...

Excel IF formula with OR logical function
Excel formula using IF OR function1

This post will guide you how to use IF function combining with OR logical function in Excel. If you want to check if one of several conditions is met in your excel workbook, if the test is TRUE, then you ...

Sidebar