StarOffice: Supressing error messages in cells
James McDonald
james
Mon May 17 12:01:04 PDT 2004
Joel Hammer wrote:
>An error message is generated in the spreadsheet if you
>divide one cell by the contents of another cell if the
>contents of the divisor cell are either undefined or 0. Is
>there a way to suppress the error message if the divisor
>cell contents are undefined?
>
>Thanks,
>
>Joel
>
>
Two specific functions
ISERROR
ISNA
Depending on the return of the formula result one returns true if's an
error or true if you get that #N/A thing.
More information about the Linux-users
mailing list