Contact
12 programs
Explore the site

Zoho Sheet ISFORMULA: Audit whether a cell contains an entered formula

Information Beginner Zoho Sheet

Use ISFORMULA to audit calculated columns for constants, distinguish formulas from displayed values, and inspect formula text.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked

Quick answer. The Zoho Sheet formula =ISFORMULA(A2) returns a Boolean (TRUE or FALSE) according to whether the referenced cell meets the function’s documented condition: detect formula content rather than merely a calculated result. The formula does not change the referenced value, fix it, or prove that other spreadsheet products use exactly the same error semantics. Zoho’s official reference was checked on October 13, 2026, but no formula in this guide was executed natively in Zoho Sheet. [Z-SELF]

Exact syntax, parameter order and defaults

ISFORMULA(cell)
Position Argument Required Zoho-documented input Example
1 cell Yes Cell reference to inspect for a formula A2

Zoho documents one required argument for ISFORMULA. There is no optional switch, no tail or match mode, and no default second argument; no further optional parameters are documented. Do not add a compatibility option copied from another spreadsheet. The official English syntax is shown above exactly, including the argument name. [Z-SELF]

What the function actually checks

ISFORMULA asks whether the referenced cell contains a formula. It does not ask whether the formula was successful. Thus the cell containing =2+2 should be TRUE, while a cell containing a typed 4 should be FALSE. A cell that contains an error-producing expression still contains a formula. [Z-SELF]

Recreate the workbook before copying results

Start in a new Zoho Sheet worksheet, not on a sheet containing business data. Enter the following input in each cell of column A. A leading = is an actual formula; the leading apostrophe on A8 intentionally forces text, and A9 must be genuinely empty. The expected display column is a reference description, not a live Zoho test result.

Cell Entry to type Expected display / type Why this row matters
A2 =NA() #N/A! error Controlled unavailable-value sentinel
A3 =1/0 #DIV/0! error Controlled arithmetic failure
A4 =SQRT(-1) #NUM! error Controlled mathematical domain failure
A5 7 7 (number) Valid constant
A6 pending pending (text) Valid text
A7 =2+2 4 (number) Valid formula, no error
A8 '#N/A! (type the apostrophe first) #N/A! as literal text Text that resembles an error is not an error
A9 leave empty Blank Missing entry, not necessarily a spreadsheet error
A10 =IFERROR(1/0;"Recovered") Recovered (text) Formula exists, but its resulting value is valid

Cell A8 must be typed with an initial apostrophe immediately followed by #N/A!, namely ' then #N/A!. The visible apostrophe is an entry convention, not part of the resulting string. Zoho’s help documents NA(), the #DIV/0! error category for IFERROR, SQRT’s negative-value error, and IFERROR’s fallback syntax. [Z-NA, Z-IFERROR, Z-SQRT]

Enter the candidate function formula in B2, then fill it down to B10. Compare your actual native results to the expected values shown below. If your workbook locale chooses different separators for multi-argument formulas, verify its own input conventions; the semicolon examples here follow Zoho’s published IF and IFERROR examples, but the function being reviewed takes exactly one argument. [Z-IF, Z-IFERROR]

Expected results: nine independent logical checks

The following table is a truth-table interpretation of the official definition, not a screenshot or native calculation. It is designed so that readers can reproduce and compare each outcome in their own Zoho workbook. [Z-SELF, Z-NA, Z-IFERROR, Z-SQRT]

Cell Candidate formula Expected result Rationale
A2 =ISFORMULA(A2) TRUE NA() is a formula regardless of error result
A3 =ISFORMULA(A3) TRUE Division is an expression entered as a formula
A4 =ISFORMULA(A4) TRUE SQRT call is a formula despite its error result
A5 =ISFORMULA(A5) FALSE Typed number is not a formula
A6 =ISFORMULA(A6) FALSE Typed text is not a formula
A7 =ISFORMULA(A7) TRUE 2+2 was entered as a formula
A8 =ISFORMULA(A8) FALSE Apostrophe-prefixed text is not a formula
A9 =ISFORMULA(A9) FALSE Empty cell is not a formula
A10 =ISFORMULA(A10) TRUE IFERROR remains a formula even though it returns text

Every cell reference in the table corresponds to the entry defined above. The expected TRUE/FALSE results are independent logical checks derived from the typed input and Zoho’s documented purpose; they were not produced by copying another spreadsheet’s execution results. In particular, the distinction between A2 (actual NA error) and A8 (NA-looking text) is intentional. [Z-SELF, Z-NA]

Formula presence is different from a calculation’s displayed result

ISFORMULA checks how a cell’s content was entered, not whether its displayed value seems computed. A cell showing 4 could hold a manually entered 4 or the expression =2+2; the results look identical, but the first is a constant and the second is a formula. Zoho’s official function description makes this distinction, and the controlled practice table exposes it directly. [Z-SELF]

That also means an error result does not automatically make ISFORMULA FALSE. For A3 containing =1/0, the cell still contains a formula although it displays #DIV/0!. This follows the definition of formula presence; Excel’s official ISFORMULA examples demonstrate the same specific case, but no native Zoho execution was performed. [Z-SELF, M-EXCEL-ISFORMULA]

Advanced audit: find accidental hard-coded values in a calculation column

Suppose E2:E7 is a report’s calculated gross amount column. E2==B2*C2, E3==B3*C3, E4=99, E5==B5*C5, E6==B6*C6, E7==B7*C7. The literal number 99 in E4 could be a deliberate manual override or an accidental replacement of a formula. Put this in F2 and fill through F7:

=ISFORMULA(E2)

Expected F2=TRUE, F3=TRUE, F4=FALSE, and F5:F7=TRUE. F4 is a prompt to investigate; it does not prove tampering or financial error. A legitimate override should be documented separately rather than silently rewritten to a formula. For the audit to work, the source column must use genuine formulas beginning with =, not imported strings representing formulas. [Z-SELF]

Make the flag readable for a reviewer

In G2, use:

=IF(ISFORMULA(E2);"Formula present";"Constant/blank: review")

Fill downward. This creates a row-by-row review status. Because ISFORMULA is TRUE for error-producing formulas too, this is a formula-presence control, not a correctness check; an independent ISERROR(E2) flag can identify failed calculations. Zoho documents both functions separately. [Z-IF, Z-SELF, Z-ISERROR]

Advanced audit: display versus formula inspection

Zoho documents FORMULA(cell) as a separate function that returns a formula as text. Use ISFORMULA first to decide which rows contain formulas, and then consult FORMULA for what formula was entered, where the specific input is supported. For example, if A7 holds =2+2, ISFORMULA(A7) is expected TRUE while FORMULA(A7) is intended to expose that expression as text. Zoho’s FORMULA examples use genuine formula-bearing referenced cells. [Z-FORMULA, Z-SELF]

This combination can support review of copied workbooks: one column marks formula presence; another, created for formula-bearing rows only, contains the formula text for a human to compare with neighboring rows. Comparing formula text by itself can be misleading when relative references differ intentionally by row, and the present guide does not claim validated normalization or auditing of array formulas. Use named audit procedures and backups rather than automatically replacing detected constants.

What ISFORMULA does not promise

An entered formula can have an incorrect reference, produce #N/A!, divide by zero, or quietly calculate the wrong number. ISFORMULA only establishes formula presence, not mathematical, semantic, or business correctness. It does not certify user identity, cell provenance, revision history, data freshness, the absence of external links, or workbook security. [Z-SELF]

A result produced by =IFERROR(1/0;"Recovered") should still test TRUE for formula presence even though its displayed value is ordinary text; the absence of a visible error does not erase the formula. Conversely, A8 is the text #N/A! and is not a formula. The workbook example makes these distinctions visible without using undocumented spreadsheet introspection tools. [Z-IFERROR, Z-SELF]

Comparison with Microsoft Excel

Microsoft’s ISFORMULA(reference) documentation similarly checks whether a referenced cell contains a formula and illustrates TRUE even for a formula producing an error. This is a documented semantic comparison to Zoho’s one-argument ISFORMULA(cell), not a claim that Excel’s treatment of names, arrays, remote references or errors is identical in Zoho. Zoho’s own article does not specify a first-supported release or precise handling of an input that is a direct numeric literal instead of a cell reference; don’t import Excel’s #VALUE! edge-case rule as a Zoho fact. [Z-SELF, M-EXCEL-ISFORMULA]

Questions readers often ask

Is ISFORMULA a way to validate a result? No: it sees formula presence. Pair it with error checks and independent domain validation. [Z-SELF]

Can it distinguish a hard-coded number from a formula result? Yes, for the documented single-cell reference case. A displayed 99 entered as a constant and 99 calculated by a formula should yield different flags, based on the documented definition. [Z-SELF]

Does ISFORMULA reveal the formula text? No; it returns TRUE/FALSE. Zoho documents a separate FORMULA function to retrieve a formula as text. [Z-FORMULA]

Errors, troubleshooting and implementation limits

Symptom or question Evidence-based explanation and next step
#NAME! rather than TRUE/FALSE A misspelled function name or malformed reference can itself fail. Check spelling, parentheses and the cell location. Zoho describes invalid names and missing quotes among causes. [Z-ISFORMULA]
#REF! in the referenced formula An invalid or deleted referenced cell can produce a reference error. The error-checking functions categorize that error, but do not repair the reference. [Z-ISFORMULA, Z-IFERROR]
#VALUE! on an unusual input Inspect the type and syntax of the supplied argument. Do not assume arrays, structured references, external-workbook references or custom-function errors match undocumented edge cases. [Z-ISFORMULA]
#N/A! expected but not produced Check whether the input is truly an unavailable-value error or only text that displays similarly. NA() is Zoho’s documented way to create a controlled unavailable error. [Z-NA]
Text "#N/A!" behaves differently from =NA() A text label is not an error value. For diagnostics, deliberately distinguish input type from its displayed appearance. [Z-NA, Z-ISFORMULA]
Results vary after importing from another product Confirm formulas and types after import. Documentation similarity between spreadsheet products is not validation of import conversion, automatic recalculation or engine edge cases. [Z-ISFORMULA, M-EXCEL]

The official help article does not provide a first-supported Zoho Sheet release, precision guarantees, complete behavior for array/range arguments, a verified account-tier matrix, or an exhaustive list of error objects. This guide is limited to Zoho’s public English-language Sheet Help as inspected on October 13, 2026. Browser, mobile, desktop/offline, regional-server and account-plan parity were not independently tested. All worksheet outputs here are expected results inferred from official function definitions; zero formulas were run inside Zoho Sheet. That distinction matters especially for unusual coercions and automatic array evaluation.

These functions complement rather than replace ISFORMULA in a complete workflow. [Z-SELF]

Evidence and reproducibility ledger (checked 2026-10-13)

The bracketed IDs are claim-level references; the description of an input type or an official syntax traces to Zoho’s public help, while the expected worksheet results are separately identified as logical deductions. Unless explicitly labelled otherwise, a comparison with Microsoft applies to Microsoft’s product, not to the Zoho engine.

Validation boundaries: Documentary research: performed against official public pages. Independent logical assertions: performed against the documented predicate using a small controlled fixture. Native Zoho execution: 0. Screenshots, connected Zoho Sheet account tests, web-mobile parity, locale-specific execution, and measured version gates: none. First-supported Zoho Sheet version: not established by the cited references.