Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
IF statement help | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |