View Single Post
  #1   Report Post  
asach
 
Posts: n/a
Default Blank a 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
"", the line goes all the way down to zero. Is there a way to completely
blank a cell rather than filling it with a space?