SheetFX
≡
<< Go back to all functions

TRUE

The TRUE function in Google Sheets returns the logical value TRUE. It is commonly used in logical expressions or as a placeholder value.

Function Syntax and Parameters

Syntax: TRUE()

Parameters: This function does not require any parameters.

Step-by-Step Tutorial

  1. Using TRUE in a logical expression:

    • Example: =IF(A1>B1, TRUE(), FALSE())
    • Result: Returns TRUE if the value in cell A1 is greater than the value in cell B1, otherwise returns FALSE.

  2. Using TRUE as a placeholder value:

    • Example: =IF(A1>B1, "Valid", TRUE())
    • Result: Returns the text "Valid" if the condition in the IF statement is true, otherwise returns TRUE.

Use Cases and Scenarios

  1. Conditional Formatting: Use the TRUE function as a condition for applying specific formatting to cells.

Related Functions

  • FALSE: Returns the logical value FALSE.

Related Articles