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

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

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

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


hth

"Peter Boardman" <Peter wrote in message
...
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

One way

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

--
Regards,

Peo Sjoblom


"Peter Boardman" <Peter wrote in message
...
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

Try this:

=AND(A1=A2,A1<0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Peter Boardman" <Peter wrote in message
...
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

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

--

HTH

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


"Peter Boardman" <Peter wrote in message
...
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