View Single Post
  #4   Report Post  
Ragdyer
 
Posts: n/a
Default

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