I need to compare character count between 2 cells with a simple TRUE/FALSE result. For example, if A1 has 8 characters and A2 has 8 characters, A3 would be TRUE. Variations of the following doesn't seem to work and I'm stuck:
A1: jfmd773udi
A2: pik83tq2zx
A3: TRUE
=if(LEN(A1),LEN(A2),"TRUE","FALSE")
A quick formula would be appreciated!!
Bookmarks