Formualizer Docs
ReferenceFunctionsInformation Functions

ISREF

ISREF: Returns TRUE when the argument resolves to a reference.

Summary

Checks reference metadata without materializing the referenced value or range.

Returns TRUE when the argument resolves to a reference.

Examples

Cell reference
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Expression is not a reference
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

Does ISREF read cell values?

No. It inspects whether the argument can resolve as a reference.

Runtime metadata

Category

Information

Signature

ISREF(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

ISODD

ISODD: Returns TRUE if number is odd.

ISTEXT

ISTEXT: Returns TRUE when the value is text.

On this page

SummaryExamplesRelated functionsFAQDoes ISREF read cell values?Runtime metadata