# IF Function Problem

#### scouser22

##### Board Regular
I have an IF function in to tell me if the figures i am picking up agree with a different set of figures.

I need the IF to 'agree' if the numbers are within £1 of each other but I can't seem to get the formula to work properly

My Formula is :

=IF(U202<>0,"Check","Agree")

On the face of it it works, but my figures are coming back with a difference around +/-0.000000000003 and I can't seem to work out what to put in the formula to say IF U202 is within +/- 1 of 0 "Agree"

A simple fix i'm sure, but can't get my head around it

Thanks

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Try

=IF(U202>0.0000000001,"Check","Agree")

Better, in case it goes negative

=IF(ABS(U202)>0.0000000001,"Check","Agree")

Replies
5
Views
417
Replies
3
Views
83
Replies
3
Views
142
Replies
7
Views
144
Replies
2
Views
263

1,203,524
Messages
6,055,910
Members
444,834
Latest member
ComputerExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back