Navigation:  Formula Reference > Spreadsheet Formula Functions >

ISREF

Previous pageReturn to chapter overviewNext page

 

This function, Is Reference, tests whether a value, an expression, or contents of a referenced cell is a reference to another cell.

Syntax

ISREF(cellreference)

ISREF(value)

ISREF(expression)

Arguments

Specify a cell reference, a numeric or text value, or an expression for the argument.

Remarks

Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

If the argument is a reference, this function returns TRUE. If the argument is not a reference, this function returns FALSE.

Data Types

Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

Examples

ISREF(B3) gives the result TRUE

ISREF(R1C2) gives the result TRUE

ISREF(12) gives the result FALSE

 

See Also

ISBLANK