blank cell formulae do nothing
 

I have created a formulae that asks if A1 = B1 then return the number 3 and
if not do nothing (for example =IF(A1=B1,3,"") and it works fine as long as
there are numbers there. My problem is that i want to set up a table and
this equasion has been draged down the page but when the cells are blank it
returns a 3 (because both cells are the same) and i only want it to show when
a number has been inserted to the relavant cells.
Please help it's driving me nuts.

blank cell formulae do nothing
 

=IF(AND(A1=B1,A1<""),3,"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul" wrote in message
...
I have created a formulae that asks if A1 = B1 then return the number 3
and
if not do nothing (for example =IF(A1=B1,3,"") and it works fine as long
as
there are numbers there. My problem is that i want to set up a table and
this equasion has been draged down the page but when the cells are blank
it
returns a 3 (because both cells are the same) and i only want it to show
when
a number has been inserted to the relavant cells.
Please help it's driving me nuts.