See if this makes it look any better:
=IF(ISERR(H3/G3),NA(),H3/G3)
Regards
Trevor
"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?
|