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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - check if 2 cells are equal but only if they contain numbers not i. (https://www.excelbanter.com/excel-worksheet-functions/22380-check-if-2-cells-equal-but-only-if-they-contain-numbers-not-i.html)

Peter Boardman

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

"Peter Boardman" <Peter wrote
in message
...

Philippe l. Balmanno

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

All times are GMT +1. The time now is 04:48 PM.