| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using contents of a check box for an in statement | Excel Discussion (Misc queries) | |||
| How do I use a "check(ed) box" as a criteria in an "=if" statement | Excel Worksheet Functions | |||
| How do I check for values in a list in an if statement? | Excel Discussion (Misc queries) | |||
| IF statement to check cell contents | Excel Worksheet Functions | |||
| How do I check formatting in an if-then statement | Excel Worksheet Functions | |||
Hybrid Mode
