I need to compare two data entries in two different worksheets. The numbers are fairly large and may be entered by different people using the workbook at different times.
So, lets say in sheet 1, A1, The data is 105560
and in sheet 2, A1 The data is 105562
I want to write a formula like, =if(sheet1!A1=sheet2!A1,"ok","error")
However, a tolerance of 2 is acceptable and so I don't really want to show an error in this case.
Is there a way of writing the formula that will allow for a tolerance of my choice when comparing two numbers. It should not matter if which way around the tolerance is (if so it would be easy).
I did think of using the Round function but I'm not dealing with decimal places.
If anyonre can help that would be smashing
So, lets say in sheet 1, A1, The data is 105560
and in sheet 2, A1 The data is 105562
I want to write a formula like, =if(sheet1!A1=sheet2!A1,"ok","error")
However, a tolerance of 2 is acceptable and so I don't really want to show an error in this case.
Is there a way of writing the formula that will allow for a tolerance of my choice when comparing two numbers. It should not matter if which way around the tolerance is (if so it would be easy).
I did think of using the Round function but I'm not dealing with decimal places.
If anyonre can help that would be smashing
