Truly null value

[Mike D.]

Hi. Is there a way to enter a TRULY null value in a
cell? I intend for the formula below to leave the cell
blank if the criteria is met. My problem is that when I
go to graph this, it graphs the point as zero. If I
completely delete the formula so that the cell is empty,
it will not graph the point at all (This is what I
want ...)

Thanks,
Mike.

 

[Peo Sjoblom]

Only workaround is to use NA()

=IF(A1="",NA(),A1)



--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)