Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |