Work with Approx. value

[Maxime Maugeais]

Hi,

Is it possible to see if two cells have the same value +- a given amount.
Example: Cell A1 has a value of 1.8568, and cell F54 has a value of 1.8564.

I would like a formula that would return "true" if A1 and F54 a the same or
almost the same (let's say 0.0005).

Rounding up does not work because in this case, A1 is rounded to 1.8570 and
F54 to 1.8560 which is a difference of 0.0010. That's too much. The formula
should return "False"

Thank you

 

[Frank Kabel]

Hi try
=IF(ABS(A1-F54)<=0.0005,TRUE,FALSE)

 

[Biff]

Hi!

I think this is what you're after:

=ABS(A1-F54)<=0.0005

Biff