StarOffice: Supressing error messages in cells

[Bruce Marshall]

On Saturday 03 April 2004 10:05 am, 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
>
> _______________________________________________
> Linux-users mailing list
> Linux-users at smtp.linux-sxs.org
> Unsubscribe/Suspend/Etc ->
> http://smtp.linux-sxs.org/mailman/listinfo/linux-users

an example:

=IF(OR(I44=" ";I44=0);" ";I44/C44)

says:  "if I44 = to blank  or =0 then set the cell to blank.   Otherwise 
divide.




-- 
+----------------------------------------------------------------------------+
+ Bruce S. Marshall  bmarsh at bmarsh.com  Bellaire, MI         04/03/04 10:49  +
+----------------------------------------------------------------------------+
"This space for rent"