# 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