|
EVAL2 function: evaluate a string
EVAL2 is an array function that evaluates a string as though it was an Excel formula or an Excel defined name, and returns the result of the evaluation, or #N/A if the string cannot be evaluated.
EVAL is NOT multi-threaded, is volatile and an array function.
EVAL2Syntax
EVAL2 (theInput)
theInput
any mixture of constants, functions, expressions, names and ranges that evaluates to a string. If the resulting string cannot be evaluated as an excel formula or defined name the function will return #Value.
EVAL2 Remarks and Limits
EVAL2 is a volatile function.
Because EVAL2 is a volatile function every formula containing an EVAL2 function will be recalculated at every recalculation.
Unqualified cell references
The input string is evaluated as though it was on the worksheet in which the function has been entered. This means that unqualified cell references like F7 will be evaluated as referring to F7 on this sheet, regardless of which sheet is active. To refer to cells on other sheets use qualified references like Sheet3!F7.
Array Formulas
The input string is always evaluated as though it had been array-entered. An array of multiple results is returned where appropriate.
Date Literals
EVAL always interprets date literals as US style dates (MMDDYY).
Maximum 255 characters
EVAL2 will evaluate a maximum of 255 characters
|
