If ABS statement
A subtle difference:
=IF(ABS(A2-B2)<0.01,TRUE,FALSE)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"maijiuli" wrote in message ...
| Hello,
|
| I'm trying to do a formula to compare 2 numbers and be within a tolerance
| level.
|
| A2= $37.73
| B2= $37.74
| A3= $100.10
| B3= $100.10
|
| Instead of if(A2=B2,true,false) I am using this formula:
| =IF(ABS(A2=B2)<0.01,TRUE,FALSE)
|
| I input this formula in A3 and B3. A3 says true but B3 says false. I'm not
| even sure if I'm using the right formula to do what I need to do.
|
| Thanks in advance,
|
|
| --
| Thank You!
|