Ignore " " values

[Phil Hageman]

The following formula (typical) provides point data for a
plotted series. Problem is, when the cell holding the
data is blank (" "), the series drops to zero. Is there a
way to have the chart ignor the " " values?

=IF(Customer!U27<>"",Customer!U27,"")

 

[dvt]

The following formula (typical) provides point data for a
plotted series. Problem is, when the cell holding the
data is blank (" "), the series drops to zero. Is there a
way to have the chart ignor the " " values?

=IF(Customer!U27<>"",Customer!U27,"")

Relplace the "" with an N/A error. For example,

=IF(Customer!U27<>"",Customer!U27,NA())

 

[Phil Hageman]

Thanks, Dave. I used #N/A and it works. Thanks,Phil