I have a cell a1 that shows 25%. But I want that cell to only show 15% as the maximum value, regardless of what how high the previous calculation is giving as an answer in cell a1.
So anything above 15% is just resulting in 15% in cell a1. Possible? Anything below 15% should be shown as it real value. Like 6% from previous calculation should be shown as 6%.