No data series line for 0 values in chart

[KHUGHES]

I am charting values from cells with formulas
=IF(C84="","",B66+C54+C56)

It is charting the "" as a 0 value. How do I prevent charting that lin
into the future if C84 is empty? I want the line in the chart to stop
As I have it formulated it drops to zero and tracks along the zer
line.

Thanks for any help,

K

 

[Debra Dalgleish]

Instead of an empty string, use the NA function:

=IF(C84="",NA(),B66+C54+C56)