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

[Chip Pearson]

Please ask your question in the body of the message, not the
subject. Subject lines get truncated.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
news:[email protected]...

 

[Philippe l. Balmanno]

Try & modify:

=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(A1=B1,"Equal",IF(A1<B1,A1&" is less than "&B1,A1&" is greater than "&B1))))