On Mon, 21 Nov 2005 12:09:06 -0800, Ted wrote:

hi, no - they contain formula, sorry.

Ah -- that makes a big difference. What is the formula?

Is there a way of gettign it to ignore
the formula and return a zero when there are no numbers in the cell - it
displays the answer to a previous formula.

Post the formulas from A1 & B1.

What was the problem with the formula I suggested?

One method of outputting a zero unless A1 and B1 BOTH contain numbers is:

=IF(COUNT(A1:B1)=2,A1-B1,0)



--ron