Google Sheets
FALSE function in Google Sheets
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 Excel
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 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
- 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
- LAMBDACreates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.LogicalExcel