Chart formula result as missing value

stewbrown

New Member
Joined
Sep 12, 2002
Messages
6
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?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Excel does not have a "missing value" category like software for statistics...

You could use:

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,917
Messages
5,575,027
Members
412,635
Latest member
Arren
Top