This directive defines how the Pebble Stream runtime should avoid possible divide-by-zero errors.


Whenever a #DIV/0! would happen, 0 is returned. The "spreadsheet", "worksheet", and "column" flags apply only to the spreadsheet, worksheet, or column in which they are present. If ":" is provided as the last parameter, that number is returned instead of 0.

Example 1

Example 2

Did this page help you?