check if 2 cells are equal but only if they contain numbers not i.

[Peter Boardman]

I want to check if 2 cells are equal but only if they contain numbers nit if
they're empty. At present with the IF function it returns TRUE when the cells
are empty and I want it ti retorn FALSE if the cells are empty

 

[doco]

=IF(ISBLANK(someCell),"TRUE")

If the cell is empty "TRUE", else "FALSE"


hth

 

[Peo Sjoblom]

One way

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

 

[Ragdyer]

Try this:

=AND(A1=A2,A1<>0)

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)