Ignore " " values

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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,"")
 
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,"")
Click to expand...

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

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