Google Sheets
TRUE function in Google Sheets
Returns the logical value `TRUE`.
=TRUE()TRUE examples
Formulas you'll actually reuse.
An explicit boolean cell for a checkbox or filter column:
=IF(D2 > 1000, TRUE, FALSE)Result
TRUEHow many rows have the flag set — TRUE as a criterion:
=COUNTIF(H2:H200, TRUE)Result
47
TRUE in Excel
Same name — your formula ports as-is.
Try TRUE in the playground
Edit the example — nothing to install.
Preloaded with the TRUE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFERRORReturns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.LogicalExcel
- IFNAEvaluates a value. If the value is an #N/A error, returns the specified value. .LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel