S stewbrown New Member Joined Sep 12, 2002 Messages 6 Sep 13, 2002 #1 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?
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 MrExcel MVP Joined Feb 14, 2002 Messages 85,201 Sep 13, 2002 #2 Excel does not have a "missing value" category like software for statistics... You could use: =IF($B63,K63/$B63,#N/A)
Excel does not have a "missing value" category like software for statistics... You could use: =IF($B63,K63/$B63,#N/A)
S stewbrown New Member Joined Sep 12, 2002 Messages 6 Sep 13, 2002 #3 I think if "" is replaced with na(), this will work.
Aladin Akyurek MrExcel MVP Joined Feb 14, 2002 Messages 85,201 Sep 13, 2002 #4 On 2002-09-13 14:42, stewbrown wrote: I think if "" is replaced with na(), this will work. Click to expand... NA() --> #N/A That is why used the #N/A value itself in the formula as a constant.
On 2002-09-13 14:42, stewbrown wrote: I think if "" is replaced with na(), this will work. Click to expand... NA() --> #N/A That is why used the #N/A value itself in the formula as a constant.