If statement error check
 

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?

If statement error check
 

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

"lghovden06" wrote in message
...
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?