Hello--
I am looking for help with a formula for the following desired result: I have a cell with a simple formula in it. I would like to modify the contents of the cell so that if the formula itself returns a value greater than x, then the cell returns only x, and if the same formula returns a value less than 0, then the cell returns only 0. Otherwise, the cell would return whatever value the formula gives between 0 and x.
I hope that makes sense. Thanks for any help you can provide.
Bookmarks