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