If ABS statement
 

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!

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!

If ABS statement
 

Thanks Niek,

Does this subtract B2 from A2 or compare. I would like to compare. The
minus sign seems confusing.
--
Thank You!


"Niek Otten" wrote:

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!

If ABS statement
 

Nevermind, I guess it doesn't matter if you subtract or compare because both
are within .01. Duh, I'm dumb.

Thanks alot,
--
Thank You!


"maijiuli" wrote:

Thanks Niek,

Does this subtract B2 from A2 or compare. I would like to compare. The
minus sign seems confusing.
--
Thank You!


"Niek Otten" wrote:

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!