Chart formula result as missing value

[stewbrown]

I have a formula such as =IF($B63>0,K63/$B63,"") that I want to be treated as a missing value for charting. Instead, it is treated as a zero in the chart. Is there a way to get Excel to return a missing value when b63<=0?

 

[Aladin Akyurek]

Excel does not have a "missing value" category like software for statistics...

You could use:

=IF($B63,K63/$B63,#N/A)

 

[stewbrown]

I think if "" is replaced with na(), this will work.

 

[Aladin Akyurek]

On 2002-09-13 14:42, stewbrown wrote:
I think if "" is replaced with na(), this will work.

NA() --> #N/A

That is why used the #N/A value itself in the formula as a constant.