Thread
:
check if 2 cells are equal but only if they contain numbers not i.
View Single Post
#
1
Philippe l. Balmanno
Posts: n/a
Try & modify:
=3DIF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(A1=3DB1,"Equ al",IF(A1<B1,A1&" is =
less than "&B1,A1&" is greater than "&B1))))
--
Philippe L. Balmanno
"Peter Boardman" <Peter
wrote in =
message ...
|=20
Reply With Quote