Spreadsheet equality tests

Why are spreadsheet cells not equal? Here are some tests.

Test cell A1 and B1:

=ISNUMBER(A1)
=ISNUMBER(B1)
 
=LEN(A1)
=LEN(B1)
 
=ENCODEURL(A1)
=ENCODEURL(B1)
 
=VALUE(A1)=B1
=A1=VALUE(B1)
=VALUE(A1)=VALUE(B1)
If you liked this posting, please feel free to leave me a comment below.
View this page on GitHub.
Posted .

Comments

Leave a Reply