G
Guest
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,
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,