Return blank cell using a formula

Here is my formula: =if(iserr(h3/g3),"",h3/g3)

The problem is I am using this data in a line chart and whenever there is a
"", my line drops all the way down to zero. Can I make the formula
completely blank the cell rather than filling it with a space?

Try

=if(iserr(h3/g3),NA(),h3/g3)

--

Regards,

Peo Sjoblom


"asach" <[email protected]> wrote in message
news:[email protected]...
> Here is my formula: =if(iserr(h3/g3),"",h3/g3)
>
> The problem is I am using this data in a line chart and whenever there is
a
> "", my line drops all the way down to zero. Can I make the formula
> completely blank the cell rather than filling it with a space?

See if this makes it look any better:

=IF(ISERR(H3/G3),NA(),H3/G3)

Regards

Trevor


"asach" <[email protected]> wrote in message
news:[email protected]...
> Here is my formula: =if(iserr(h3/g3),"",h3/g3)
>
> The problem is I am using this data in a line chart and whenever there is
> a
> "", my line drops all the way down to zero. Can I make the formula
> completely blank the cell rather than filling it with a space?