This article describes the formula syntax of the EVAL function.

Call xlfEvaluate on cell.

EVAL(cell)

cell is a cell to be evaluated.

The Excel function `xlfEvaluate`

uses the Excel engine to evaluate
its argument, just like pressing `F9`

evaluates selected text
in the formula bar. A naked string like `abc`

is interpreted as
a named range and it's corresponding value is returned.
To get `EVAL`

to treat it like
a string it must be enclosed in quotes, `"abc"`

.
If a string is a case-insensitive match with `TRUE`

or `FALSE`

it is converted to the appropriate boolean value. If the string matches a known
Excel error then the string is converted to an error type. If the string
looks like a function call then Excel calls the function and returns the result.
Use an initial equal sign (`=`

) to force Excel to evaluate the
string as a function. To parse a string as a date use the `VALUE()`

function.

Two dimensional ranges are enclosed in curly braces, use commas for
field seperators, and semi-colons for record seperators.
For example, evaluating the string `{1.23,"abc";fAlSe,#N/A}`

results in the 2x2 range consisting of the number `1.23`

,
the string `abc`

, the boolean `FALSE`

value,
and a "not available" error type. Excel will not attempt to evaluate
any item in a multi-dimensional range as a function.