On 09/21/09 22:56, Regina Henschel wrote:
=ISREF(D1:D3!C2:E2) returns TRUE
but
=ISREF(INDIRECT("D1:D3!C2:E2")) returns FALSE
=ISREF(A1~B1) returns TRUE
but
=ISREF(INDIRECT("A1~B1")) returns FALSE
And INDIRECT("(A1:C3):(B2:D4)") fails too.
Are expressions as text not allowed for INDIRECT or are they allowed
but not implemented yet?
INDIRECT is supposed to parse a reference, not any more complex
expression.
So what is a 'reference'? For ISREF the help say, "Tests if the argument
is a reference. Returns TRUE if the argument is a reference, returns
FALSE otherwise." Taking that, D1:D3!C2:E2 is a 'reference'.
The result of the expression is a reference, just like the result of
"OFFSET(A1;A2;A3)". As part of a formula, like your ISREF example, the
expression is evaluated, and the ISREF function only handles the result.
For INDIRECT, the parameter is a string, which may be the result of some
other calculation, but the string isn't parsed and evaluated before it's
passed to the function.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
