I have this formula:
=IF(A1>1599,A1,0)
It returns all the items that are above 1600, but I need to figure out how to cap it at 3200. If an item is between 1600 and 3200, I need to return that number, but if it's above 3200, I need the formula to return 3200. I hope that makes sense.
Bookmarks