View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Try

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

--

Regards,

Peo Sjoblom


"asach" wrote in message
...
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?