Lots of excel's functions will treat that as a zero (like =sum()).

But some will blow up real good:
=a1+a2

Maybe:
=n(a1)+n(a2)

would be ok for you.



mrssm5 wrote:

I have an empty cell because of "" in the formula but in a new formula
referencing that cell I want it to be read as zero? Help

--

Dave Peterson