No data series line for 0 values in chart

K

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
 
D

Debra Dalgleish

Instead of an empty string, use the NA function:

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