Contact
12 programs
Explore the site

ONLYOFFICE ISFORMULA Function: Detect Formula Cells

Information Intermediate ONLYOFFICE Spreadsheet Editor

Use ONLYOFFICE ISFORMULA to distinguish formulas from manually entered values, including formulas showing blank results or errors.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: =ISFORMULA(A2) returns TRUE if A2 contains a formula, and FALSE if it contains an ordinary typed value or is empty. This is a check of how a cell is populated, not a test of the displayed result. A cell showing 5 may hold either a typed 5 or =2+3; ISFORMULA distinguishes them.

Availability and version history

  • Introduced: The original introduction version and date are not established by the official sources checked.
  • Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
  • Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
  • Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

Syntax and required argument

=ISFORMULA(reference)
Argument Required? Definition
reference Yes Reference to the cell being checked for a formula.

The ONLYOFFICE reference says the function returns TRUE for a formula in the referenced cell and FALSE otherwise. There is no optional argument, omitted-value default or second mode parameter. The reference page’s wording additionally mentions an array-formula context; it does not establish specific behaviour for multi-cell ranges, spilled arrays or cross-sheet reference shapes. Examples here deliberately use one referenced cell each.

Hands-on worksheet example

Build the following sheet manually, entering each item exactly as shown, then put =ISFORMULA(A2) in B2 and fill through B8. Empty means leave the cell completely empty; text values should be typed without a leading =.

Row Enter into A Expected display in A Expected ISFORMULA result
2 =2+3 5 TRUE
3 5 5 FALSE
4 ="Approved" Approved TRUE
5 Approved Approved FALSE
6 =IF(1=2,"Yes","") Empty-looking string TRUE
7 (leave completely empty) Blank FALSE
8 =1/0 #DIV/0! TRUE

These are documentation-based expected classifications, not application-observed outputs. In particular, displaying an empty string does not turn a formula cell into an empty physical cell; likewise, a formula returning an error is still a formula. If the locale requires semicolons rather than commas in IF, adapt A6 appropriately and verify it natively.

Advanced audit: show calculated versus manual values

To flag cells that depend on formulas, type into B2 and fill down:

=IF(ISFORMULA(A2),"Calculated","Manual or blank")

For the sample, B2 should be Calculated, B3 Manual or blank, and B6 Calculated. This is helpful for auditing a workbook before manually overwriting an important calculation.

To distinguish truly blank cells from a manual value, compose ISFORMULA with ISBLANK:

=IF(ISFORMULA(A2),"Formula",IF(ISBLANK(A2),"Empty cell","Manual value"))

For A2 =2+3 the expected result is Formula. For a physically empty A7 the expected result is Empty cell. A numeric constant 5 in A3 should be Manual value. A cell containing a formula that evaluates to an empty string should remain Formula because ISFORMULA is evaluated first.

This example is for one-cell references. For a large audit, copy the formula row by row or use a deliberately designed helper column. The vendor function page alone does not justify claims about whole-range dynamic spilling.

Common mistakes and troubleshooting

Observation Cause or consideration Recommended check
Two cells display 5 but have different results One is a typed number; the other is a formula producing 5 Inspect the formula bar.
A visually blank cell returns TRUE It contains a formula returning "" Inspect =IF(..., "", ...) and other formula logic.
An error cell returns TRUE The error was produced by a formula ISFORMULA is not an error detector; use ISERROR for that.
An empty cell returns FALSE There is no formula in that cell This is expected.
A referenced cell is not recognized The reference might not point to the intended cell Verify sheet name, row, column, and relative references.
A multi-cell range behaves unexpectedly Range/array details are not established by the checked page Reduce to a single-cell reference and test on the target version.

ISFORMULA vs. ISBLANK: ISFORMULA asks whether the cell contains a formula; ISBLANK asks whether the cell is empty. ISFORMULA vs. ISERROR: a formula can return a valid result or an error, so these are different tests. None of the three should be used to infer spreadsheet author intent or that a formula is correct.

Editor versions, locale and compatibility limitations

The English function reference documents ISFORMULA without a first-supported release number or a fully specified ONLYOFFICE Docs-versus-Desktop behaviour matrix. The Formula tab instructions cover web and desktop interfaces in general; this is not native execution evidence. A simple =ISFORMULA(A2) has no separator, but nested IF examples contain commas and may require locale-specific syntax changes. Behaviour with external references, merged cells, multi-cell arrays, structured tables and imported compatibility formulas needs separate native checking.

Official documentation and verification ledger

Verification limits: Official rules and every displayed example were independently checked. No native ONLYOFFICE execution or localized formula test was performed. Historical release support, undocumented coercion and any array/date-system boundaries noted above remain untested.