Excel
TRUE function in Excel
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 Google Sheets
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 Excel gets this done.
- ANDReturns TRUE if all of its arguments are TRUELogicalGoogle Sheets
- BYCOLApplies a LAMBDA to each column and returns an array of the resultsLogicalGoogle Sheets
- BYROWApplies a LAMBDA to each row and returns an array of the resultsLogicalGoogle Sheets
- FALSEReturns the logical value FALSELogicalGoogle Sheets
- IFSpecifies a logical test to performLogicalGoogle Sheets
- IFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formulaLogicalGoogle Sheets