Can anyone explain why this returns false when I try to equate the two? The two are exactly the same.
I'm basically trying to do a validation here and make sure the numbers match up. I want to check if cell B4 equals cell L2 on a different spreadsheet. The value in B4 is $2642.90 and the value in L2 is $2642.90. I set cells E3 to be equal to B4 and E4 to be equal to L2 (on the other sheet), so it is clearer to see the problem.
Thanks in advance!
The image can be found at: http://imgur.com/HQanPdi.