If statement error check

[lghovden06]

I've created a Sales Tax Ledger where
Net Sales - Resale - Non-Tax - Process - Other - Gas&Diesel = Taxable
2% Tax + 7%Tax should equal Taxable. I want to create a column to check to
see if they are equal to check for errors.
I typed =IF(H4=J4+K4,"","Error")
The function works exept on some cells it displayed an error when there
shouldn't be. I then evaluated the formula and it showed J4+K4 = 127.5 and
H4=127.500000001 that was where the error came from, but I never typed a
..500000001. How do I get this to stop?

 

[Peo Sjoblom]

Here's the reason

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

in your case you should probably be able to use ROUND(data,2)



--


Regards,


Peo Sjoblom