I have 2 columns, both summed. If the sums equal, the 3rd column is to say
"ok". If they don't, it says "check bal". We have been doing this for
months. Today I entered "197.14" in both columns. The sum total is the
same. The IF column says "check bal". I can put in "197" and it works,
"197.12" works, "197.13" & "197.15" work. "197.10" also doesn't work. We
finally added 197.14 to a total in another cell & it worked fine. We
reformatted & made sure everything was numbers & that there was no rounding
in the total numbers. Any ideas? Thanks!