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
Bookmarks