Previous section-----Next section

DATA

• The DATA function is typically used inside EVAL, EXPR, or RULE calls.
• Example: =EVAL("FileNames",DATA("*"),DATA("C:\")).
• You can wrap numeric data in the DATA function to ensure numeric calculation methods are used instead of symbolic methods. The former is often much faster.
• Example: =EVAL("Eigenvalues",DATA(A1:B2)).
• Unlike EXPR ranges, DATA ranges can contain empty cells or errors.
=DATA(range) trims empty cells and errors from the end of range.
• See also: EVAL, EXPR, RULE.