ReferenceFunctionsInformation Functions
ISFORMULA
ISFORMULA: Returns whether a value originates from a formula.
Summary
Current engine metadata does not track formula provenance at this call site.
Remarks
- This implementation currently returns FALSE for all inputs.
- Errors are not raised solely due to provenance unavailability.
- Arity mismatch returns
#VALUE!.
Examples
Literal value
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
false
Computed value in expression context
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
false
Related functions
FAQ
Can ISFORMULA currently detect formula provenance?
Not yet. This implementation always returns FALSE because provenance metadata is not tracked here.
Runtime metadata
Category
Information
Signature
ISFORMULA(arg1: Any)Arity
min 1, max 1
Arguments
arg1Any · Scalar
Caps
PURE
Source