Formula Error Message

[Chambersteacher]

Is there a way to not have the formula error message DIV/0! display in a cell
and still keep the formula?

[duane]

=if(iserror(formula),0,formula)

you could substitute "" for the 0 if you prefer

[Myrna Larson]

If the formula is, e.g., =a1/b1 change it to =IF(B1=0,"",A1/B1)


On Tue, 8 Mar 2005 20:01:03 -0800, Chambersteacher
<[email protected]> wrote:

>Is there a way to not have the formula error message DIV/0! display in a cell
>and still keep the formula?