Zoho Sheet FALSE: Boolean Values and Optional Review Conditions
Return a logical FALSE in Zoho Sheet, check its type, distinguish it from text or zero and use it as the neutral value for an optional OR condition.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =FALSE() always returns logical FALSE and takes no arguments. It is useful as an explicit disabled flag or a neutral argument in an OR expression. It does not test whether another cell is false.
Availability and version history
- Introduced: Original introduction release and date are not established by the checked sources.
- Availability: Currently documented in Zoho Sheet’s rolling web-service help; no retirement endpoint is established.
- Scope: English web-service documentation. Exact mobile and offline-client parity is unverified.
- Checked: October 14, 2026, against the official FALSE reference. Documentation and independent typed/exact calculations; no native Zoho Sheet test.
Syntax and the stored value
=FALSE()
Zoho also documents that entering the unquoted word false in a cell converts it to a logical FALSE by default. Use the function when you want the formula to make that intention explicit.
Logical FALSE, numeric zero, text “FALSE” and an empty cell are different values or states. A function can have a conversion rule for some of them, but similar displays do not prove identical stored types.
Reproducible type controls
Create FalseTypes with Input formula, Is logical and Is text in A1:C1. Enter the A formulas below. Put =ISLOGICAL(A2) in B2 and =ISTEXT(A2) in C2, then fill B2:C2 through row 6.
| Row | Formula in A | Expected B | Expected C |
|---|---|---|---|
| 2 | =FALSE() |
TRUE | FALSE |
| 3 | ="FALSE" |
FALSE | TRUE |
| 4 | =0 |
FALSE | FALSE |
| 5 | =2<1 |
TRUE | FALSE |
| 6 | =TRUE() |
TRUE | FALSE |
B2 is TRUE because FALSE is a logical value. B4 is FALSE because zero is numeric. A5 produces logical FALSE by evaluating a comparison; it has the same logical type as A2 even though the formula is different.
For another direct check, enter =NOT(FALSE()) in E2; expect TRUE. In E3 enter =IF(FALSE();"Selected";"Not selected"); expect Not selected. The false condition chooses the stated third argument rather than a guessed omitted-argument default.
Add a global review flag without changing row inputs
Create ReportChecks with headings Report, Complete, Discrepancies, Review required and Optional check in A1:E1. Enter the exact text and numeric values:
| Row | A | B: Complete | C: Discrepancies |
|---|---|---|---|
| 2 | R1 | Yes | 0 |
| 3 | R2 | No | 0 |
| 4 | R3 | Yes | 2 |
| 5 | R4 | No | 3 |
Put Review all in G2 and =FALSE() in H2. In D2 enter =OR(B2<>"Yes";C2>0;$H$2) and fill through D5. Expect FALSE,TRUE,TRUE,TRUE.
With the global flag FALSE, the other conditions determine the result. Change H2 to =TRUE(); all four results become TRUE. The source data did not change, but the policy flag now requests review for every row. Restore H2 to FALSE() afterward.
In F2 enter =IF(D2;"Review";"No flagged issue") and fill through F5. After restoring H2, expect No flagged issue,Review,Review,Review. A FALSE result means neither of these specific checks raised a flag; it is not a universal certification that a report is correct.
Advanced: a neutral FALSE for an optional condition
Put Check discrepancies in G3 and =TRUE() in H3. Enter this formula in E2 and fill through E5:
=OR(B2<>"Yes";IF($H$3;C2>0;FALSE()))
With H3 TRUE, expect FALSE,TRUE,TRUE,TRUE. Change H3 to =FALSE(); expect FALSE,TRUE,FALSE,TRUE. The missing-completion check remains active in both cases. R3 changes because its only flagged condition was a discrepancy; R4 still requires review because it is incomplete.
This pattern is appropriate only when the discrepancy check really is optional for the intended worksheet. Do not disable a required condition merely to make the output look clear. Restore H3 to TRUE after the exercise.
FALSE is neutral in OR: OR(x,FALSE) preserves a valid logical x. FALSE is not neutral in AND; AND(x,FALSE) makes the combined result false. The choice depends on how the rule is composed.
Truth controls isolate that distinction
On FalseControls, enter =FALSE() in A2 and =TRUE() in A3. Enter =OR(A2;FALSE()) in B2, =AND(A2;FALSE()) in C2 and =NOT(A2) in D2. Fill B2:D2 through row 3.
| Row | Expected B | Expected C | Expected D |
|---|---|---|---|
| 2 | FALSE | FALSE | TRUE |
| 3 | TRUE | FALSE | FALSE |
The neutral-value identities describe valid logical inputs. They are not a promise that the engine short-circuits evaluation or hides errors in the other arguments.
Errors and related functions
The documented FALSE signature contains no arguments. Its generic error table does not establish the exact result of every malformed call, deleted reference in a larger formula or extra parameter. Diagnose the surrounding formula separately from the constant itself.
TRUE provides the opposite constant. ISLOGICAL and ISTEXT inspect types, while NOT, OR, AND and IF implement the demonstrated rules. Follow Zoho’s semicolon separators for these multi-argument examples.