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)
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)
Comments
Leave a Reply