How do I retain blank cell status in an IF statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a monthly multiline graph to which I add data by day. The graph lines
terminate at the first empty cell (day) in the series, which is what I want.
However, If I use an IF statement to prime the cells dynamically the graph
lines drop to zero. I have not been able to achieve the desired result using
"", #NA or NA().
 
Thanks Jerry - the second site listed appears to be on the track I'm wanting.
Will try it!
 
Back
Top