ExcelFlux

ISFORMULA function

TRUE if there is a reference to a cell that contains a formula.

Information · Excel 2013+

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Distinguish calculated cells from hard-coded values even when their results match.

A worked example from the workbook

RowAB
6InputInspected cell
72—
84—
9612
Record 1
=ISFORMULA(B7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ISFORMULA(B7)
Turkish Excel · tr-TR
=EFORMÜLSE(B7)

Worked examples

Distinguish calculated cells from hard-coded values even when their results match.

Use the blue inputs in the table starting at A6. F7:F9 calculate results and G7:G9 retain the original values for comparison.

Source cells containing formulas

  • B7 → =A7*2
  • B8 → =A8*2
Row A B
6 Input Inspected cell
7 2 —
8 4 —
9 6 12
Trial Expression Sample output
Record 1 =ISFORMULA(B7) TRUE
Record 2 =ISFORMULA(B8) TRUE
Record 3 =ISFORMULA(B9) FALSE
Microsoft Excel reference