- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Logical - TRUE Function
Description
The TRUE function returns the logical value TRUE.
You can use this function when you want to return the value TRUE based on a condition. Example = IF (A1 = 1, TRUE ()).
You can also enter the value TRUE directly into cells and formulas without using this function. Example = IF(A1 = 1,TRUE).
If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.
Syntax
TRUE ()
Arguments
The TRUE function syntax has no arguments.
Notes
The TRUE function is provided primarily for compatibility with other spreadsheet programs.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_logical_functions.htm
Advertisements