See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
"Tony" wrote:

I have a spreadsheet with decimals at 2 places, but certain numbers result in
amounts greater than 2 decimal places resulting in a wrong answer to the
logic statement. The numbers are not rounded, but input directly.