DPL 9 Help

Error Spreadsheet Functions

Error Spreadsheet Functions

DPLExcelMeaning
@naNA( ) The error "no value is available."

When DPL encounters this function during analysis, it will terminate with the message "@na encountered during execution" and provide the name of the variable.

There are four ways for DPL to encounter @na during evaluation:

- During spreadsheet conversion, DPL replaces unsupported functions with @na.

- During array formula evaluation, DPL fills unfilled rows or columns of the result array with @na.

- During array evaluation, DPL fills array elements with @na when the element expression contains an error (for example, requires division by 0).

- During evaluation of any expression in which you have coded an @na function.

Versions: DPL Professional, DPL Enterprise, DPL Portfolio

See Also

Spreadsheet Functions