blank cell formulae do nothing

[Paul]

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.

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"Paul" <Paul@discussions.microsoft.com> wrote in message
news:8AF1157E-3207-4533-AD91-ADE7F3BA4632@microsoft.com...
> 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.