Tolerance within formula for currency?

[Fatal Lordes]

Ok, I'm no Excel expert - very basic but I use google to work out things. But I'm stumped on this formula which uses IF statement:

=IF(ABS(B7-B4)<=0.05,"OK",IF(B7>B4,"Over",IF(B7<B4,"Under")))

Both B7 and B4 are currency cells ($0.00). I'm trying to have a tolerance of 0.05. Assuming B4 is $41.66, it works saying "Ok" if B7 is $41.61, or says "Under" if B7 is $41.60 BUT it fails if B7 is $41.71 because it says "Over" when it should say "Ok" as within the +/- 0.05c range. Why? And how do I fix it?

[Pepe Le Mokko]

Hi
without seeing the real data , a wild guess : https://docs.microsoft.com/en-US/off...ccurate-result
The article explains methods to correct the error

[Fatal Lordes]

Sorry, what else do you need me to clarify for you? The formula is exactly as in my spreadsheet and I've advised the field contents for B7 and B4 (the only two involved in this formula) and I've given the examples of where it does work but more importantly where it doesn't work. What else do you actually need me to give you? Sorry, I am new to Excel so perhaps I'm missing something. Should I upload my spreadsheet or something?

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[Marius44]

Hello
Try this =IF(round(ABS(B7-B4),2)<=0.05,"OK",IF(B7>B4,"Over","Under"))

Hello,
Mario

[Fatal Lordes]

That works!!! Fantastic! I will google "Round" to work out why it works (I'm thinking the "2" is telling it to round to two decimal places but that is my guess so I will google). Thank you so much!!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Fatal Lordes]

Ive done both of that. Thanks.

[Pepe Le Mokko]

That works!!! Fantastic! I will google "Round" to work out why it works (I'm thinking the "2" is telling it to round to two decimal places but that is my guess so I will google). Thank you so much!!

Just read my post #2 to understand why ROUND is necessary

[Pepe Le Mokko]

Sorry, what else do you need me to clarify for you? The formula is exactly as in my spreadsheet and I've advised the field contents for B7 and B4 (the only two involved in this formula) and I've given the examples of where it does work but more importantly where it doesn't work. What else do you actually need me to give you? Sorry, I am new to Excel so perhaps I'm missing something. Should I upload my spreadsheet or something?

If you were responding to me I don't see what's wrong with the provided information. Just read the article by Microsoft