Comparing two numbers but allowing a tolerance

[WelshMage]

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

 

[VoG]

Try like this

=IF(ABS(Sheet1!A1-Sheet2!A1)<=2,"OK","Error")

 

[WelshMage]

I sure will try it. Thanks

By the way, what is the ABS bit directly after =if(

 

[VoG]

ABS converts negative or positive numbers to positive.

 

[diddi]

the ABS() function is 'Absolute value" it means make always positive so in this example, it doesnt matter which number is bigger, the difference will always be positive.

 

[WelshMage]

Chaps

Works puuurrrfectly!

Many thanks