So far I have the following:
=if((A1=B1),"OK","ERROR") - if cell A1 and B1 match, it shows "OK", if not, it shows "ERROR"
This is basing the numbers on monetary values, so all cells are formated in 'accounting'.
The formula itself works fine, but if:
A1 contains 20.000002
B1 contains 20.000003
Then both round up to £20.00, but as they are both not completely identical, it shows "ERROR"
How can I amend the formula to only look up to the 2nd decimal place, and no further?
Thanks
Bookmarks