Excel functions / Information
ISREF function
TRUE if the value is a reference to a cell or range.
Syntax
=ISREF(value)
Arguments
value: What to check.
When to use it
ISREF is TRUE when its argument is a cell or range reference and FALSE for anything else. Its main use is to check, with INDIRECT, whether text names a real range.
Examples
A cell
A B C 1 Value 2 42 TRUE In C2:
=ISREF(A2)→ TRUEDoes this text name a range?
A B C 1 Range 2 'B9:B12 TRUE In C2:
=ISREF(INDIRECT(A2))→ TRUE
Common mistakes
- Text is not a reference. ISREF("A1") is FALSE: the text has to go through INDIRECT first.
ISREF in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: JE.ODKAZ
- Danish: ER.REFERENCE
- Dutch: ISVERWIJZING
- Finnish: ONVIITT
- French: ESTREF
- German: ISTBEZUG
- Hungarian: HIVATKOZÁS
- Italian: VAL.RIF
- Norwegian: ERREF
- Polish: CZY.ADR
- Portuguese (Brazil): ÉREF
- Portuguese (Portugal): É.REF
- Russian: ЕССЫЛКА
- Spanish: ESREF
- Swedish: ÄRREF
- Turkish: EREFSE