Null value in dynamic range

[dmheller]

All,
I have a data set I get from DCS system. Sometime it goes down and shows "Null"
I have a dynamic range in the name manager that works but am having problems with the null
in column z
=if(and(isnumber(g5),$Z$1=TURE),O5,NA())
to explain, G5 is a date and It goes down the column so far.
Z1 is true or false based on a check box
O5 is data that goes down so far.
the problem, when O has series of null values for 50 data points, my data then has It and my graph Is off. how can I make null a number?

 

[Kamolga]

Yoy can select cells, then ctrl+f and replace null by 0.

This macro would do it as well

Sub NullReplace()
On Error Resume Next
 Cells.Select
Selection.Replace What:="null", Replacement:="0"
End Sub