StarOffice: Supressing error messages in cells

[Tim Wunder]

On Saturday 03 April 2004 10:50 am, someone claiming to be Bruce Marshall 
wrote:
> 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.

That's fin if you want to suppress for the values of i44=<blank> or 0, but if 
i44=null, then that won't work. 
Try using =iserr, or =iserror:
=if(iserr(i44/c44);"";i44/c44) or
=if(iserror(i44/c44);"";i44/c44)

HTH, 
Tim

-- 
Fedora Core 1, Kernel 2.4.22-1.2174.nptl,  KDE 3.2.1, Xfree86 4.3.0
 12:25:01  up 27 days,  4:28,  1 user,  load average: 0.00, 0.07, 0.11
It's what you learn after you know it all that counts