Create Maximum Value that appears in column

**excelstudent24** · 06-18-2013, 03:40 PM

I have attached a spreadsheet that I need help with.

I need to adjust this spread sheet to where it keeps the true annual % Change values (Column D); however if the value is above 5% I want the cell to show 5%.

Essentially, I need the maximum percent increase to be 5%, but have the spreadsheet still be able to show the true value if you click on the cell and the value is greater than 5%.

Is this possible?

Any help would be greatly appreciated.

Thanks!!

**Ace_XL** · 06-18-2013, 03:59 PM

Try

=MIN(0.05,(B17-B5)/B5)

Contradictory statements

however if the value is above 5% I want the cell to show 5%. and
but have the spreadsheet still be able to show the true value if you click on the cell and the value is greater than 5%.