Thursday, 4 May 2017

Excel - The Excel ISREF Function

Description

The Excel Isref function tests if a supplied value is a reference. If so, the function returns TRUE; Otherwise it returns FALSE.
The syntax of the function is:
ISREF( value )
Where the supplied value argument is the value or expression to be tested.

Isref Function Examples

The following spreadsheet shows examples of the Excel Isref function:

Note that, in cell A5, the expression B1 * B2 returns a value (the product of the values in two cells), and so in this case, the Isref function returns FALSE.

No comments:

Post a Comment