Chart plotting/getting n/a value

[Naoki]

I have a chart which will be pulling data, including zero values an
#REF! values, but I need it to not display these values in the chart.
I understand that the data must be #N/A to not be pulled into th
chart... and I have calculated the following:

=IF(E64=0,NA()) will turn a zero value into #N/A

and

=IF(ISERROR(ERROR.TYPE(E64)),E64,IF(ERROR.TYPE(E64)=4,NA(),"")) wil
turn a #REF! error into #N/A

My question is a simple one. How do I combine the two equations so
can make sure either condition will result in the #N/A value

 

[Naoki]

realized those formulas weren't returning the value in the event th
cell they referenced did contain data...

=IF(E59=0,NA(),E59)

AND

=IF(ISERROR(ERROR.TYPE(E59)),E59,IF(ERROR.TYPE(E59)=4,NA(),E59))

my question still remains... how do I combine them

 

[Frank Kabel]

Hi
try
=IF(ISERROR(E64),NA(),IF(E64=0,NA(),E64))

 

[Naoki]

That works great for combining the zero values and the #REF! error, the
both become #N/A now which is perfect for making sure neither ge
plotted.

Only problem now is that it doesn't include the condition which wil
pass through DATA if someone did enter legitamate data.

How do I do that?

Thanks again

 

[Naoki]

haha, it does work... was referencing the wrong cell!

Its amazing that the 'more' basic excel stuff fustrates me the most..
after looking at VBA code for the most of my work, my mind must b
warped.

Sorry for doubting it, it works flawlessly