View Single Post
  #1   Report Post  
Elan
 
Posts: n/a
Default Empty Cell calculation

I have a column with formulas.
When formulas return empty cell (""), the chart seems to handle
it as a 0. I do not want to display those data points at all.
I tried to use NA() instead of .
The chart seemed to be o.k. but now I have a problem finding MAX/MIN Values
of this column because I have there now both numbers and #N/A.
Thanks in advance,
Elan