View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maijiuli maijiuli is offline
external usenet poster
 
Posts: 56
Default 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!