ISFORMULA in WPS Spreadsheet: Check Whether a Cell Contains a Formula

=ISFORMULA(reference)

The required argument is a reference to the cell being inspected. ISFORMULA checks formula presence, not whether the calculated value is correct, numeric, nonempty or error-free.

The official example explicitly classifies a division-by-zero formula as TRUE because the cell still contains a formula. This distinction is useful when checking how a workbook was constructed: an unsuccessful calculation does not become a literal constant merely because its displayed result is an error.

On a fresh worksheet, prepare these cells. Enter formulas as formulas, not quoted strings.

In B2 enter =ISFORMULA(A2) and copy down through B5. The documentation-based expected Boolean results are TRUE, FALSE, FALSE, TRUE.

The first two rows are deliberately similar in displayed value but different in construction. The last row tests formula presence independently of calculation success. These are explicit same-sheet scenarios; no native WPS execution is claimed.

Suppose a worksheet’s totals are intended to be calculated from other cells. A parallel ISFORMULA column can identify cells that have been replaced by literal values. A FALSE result may warrant inspection if the design requires a formula in that position.

It is not automatically an error to use a constant. Some cells intentionally contain approved fixed inputs, and some calculations are deliberately replaced by snapshots. The function supplies a fact about cell content; a separate worksheet design rule determines whether that fact is acceptable.

A TRUE result also does not prove that the formula references the right cells or implements the right calculation. For example, =1+2 is a formula regardless of whether the intended result was a sum of business data. Combine formula-presence checks with review of the actual expression and its inputs.

Pass the cell reference, as in A2, rather than the quoted address text "A2". Those are different input types. This guide uses only direct references and does not infer how names, generated references or multi-cell ranges behave.

Likewise, a text string that resembles a formula is not the same as a cell containing an active formula. If a source column was imported as text, inspect its actual cell type before interpreting what looks like an equals-sign expression.

The official lesson says an invalid reference data type can yield #VALUE!, giving a non-reference defined name as an example. The worked cases do not create invalid names or rely on that broader mechanism. They use valid single-cell references only.

External workbooks, protected formulas, array ranges, empty cells and dynamic spill behavior are outside these controls. No inference is made about every current edition’s treatment of those cases. The result is a logical classification, not a formula extractor, recalculation trigger or workbook-integrity certificate.

The official WPS Academy ISFORMULA lesson, published 2020-09-02, has the applicability scope recorded below. It was reviewed on October 18, 2026. The applicability field explicitly names WPS Office for Windows Personal. The numeric build, introduction release and last supported version remain unknown. The source does not identify this function as deprecated or retired. Support in Linux, other editions and other platforms is not established by this lesson.

The worked examples are original documentation-based expectations, supported by independent reasoning and arithmetic where applicable. They were not executed in WPS. Historical vendor demonstrations are documentation, not our application tests; no screenshot or runtime precision guarantee is supplied. English names and comma separators follow the lesson. Localized entry, workbook interchange and exact output formatting require verification in the intended client.

• FORMULATEXT: read a formula’s text when available.
• ISNUMBER: test a value’s numeric type rather than formula presence.