Conditional IF Formula

[Dolphin123]

Im trying to use the IF formula: IF (A2=B2, true, false).
But if A2 is $26,466.48 and B2 is $26,466.49 this is close enough for my purposes and I would like the result to be 'true' rather than false. Can I define a parameter (such as within $0.50) to generate a true result?

Thank you.

 

[MrKowz]

Try:

=IF(ABS(A2-B2)<=0.5,TRUE,FALSE)

Or, alternatively we could round them to 1 decimal place for a bit more accuracy:

=IF(ROUND(A2,1)=ROUND(B2,1),TRUE,FALSE)

Or if you simply want a TRUE/FALSE displayed, we can remove the IF altogether:

ABS(A2-B2)<=0.5
=ROUND(A2,1)=ROUND(B2,1)

 

[Dolphin123]

Thank you for the quick response -- much appreciated!