I have two sets of rows that I want to match on account number. I have
formatted them both to number if I subtract one from the other I get zero and
if I add them I get the sum but if I use the following

=IF(D2=L2,1,0)

I still get zero. Can someone explain?