I. Intro
The TRUE function can be used to return the logical value TRUE.
II. About the function
- Formula: =TRUE()
- Example: =IF(B1> A1, TRUE()) evaluates whether B1 is greater than A1. If it meets this condition, it returns TRUE, otherwise it returns FALSE. The TRUE() in the formula can be directly replaced with TRUE.
Note: The TRUE function has no arguments and is rarely used by itself. It is usually nested into other functions. Similar functions include the FALSE function. For more details, see FALSE function for Sheets.
250px|700px|reset
III. Steps
Use the function
- Open the spreadsheet, select a cell, and enter the formula. For example: =IF(B2>60,TRUE()).
- Press Enter to get the result.
250px|700px|reset
Delete the function
Select the cell with the function and press Delete.