Help with IF function and positive or negative results

[BallHawk]

Here is my situation. I need to create a formula that will give me a 0 (zero) if the result is between 5 and -5. If the result is outside that range (for example 6 or -6) I want the value to show up as 6 or -6.

So if A1 - B1 is between 5 and -5 I want the cell to just show a zero as the result but if it is outside that range (positive or negative) I want the result to show. I hope I explained this well enough.

Thank you very much to all who respond

[Cutter]

Try this:

=IF(AND(A1>=-5,A1<=5),0,A1)

[BallHawk]

Thanks Cutter!