So i have a starting value and i need to add values to that, but the count may not go above 5000 and not go below 0.
i know you can use these formulas for that:
=MaX(0,(A5+A6))
=MIN(5000,(A5+A6))
I just cant find out how to use both limits in the same cell. is there any one who can help?
Bookmarks