EXCEL FUNCTION IF

[LARRY]

QUESTION:
I AM SETTING UP A FUNCTION USING THE IF STATEMENT
BOTH A AND B ARE REFFERING TO OTHER CELLS (LINKED)

EXAMPLE
=IF(A-B=0,TRUE,A-B)

I WANT THE CONDITION TO BE TRUE IF THE NUMBER IS WITH IN 5.
-5 TO 5

 

[Bob Phillips]

=ABS(A1-B1)>=5