Excel
FALSE function in Excel
Returns the logical value FALSE
=FALSE()FALSE examples
Formulas you'll actually reuse.
A shipped flag that is FALSE while the ship date is blank:
=IF(E2 = "", FALSE, TRUE)Result
FALSEHow many rows still have the flag cleared:
=COUNTIF(H2:H200, FALSE)Result
152
FALSE in Google Sheets
Same name — your formula ports as-is.
Try FALSE in the playground
Edit the example — nothing to install.
Preloaded with the FALSE 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
- 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
- IFNAReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expressionLogicalGoogle Sheets