ExcelBanter - Setting a maximum field value to 100%

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Setting a maximum field value to 100% (https://www.excelbanter.com/excel-programming/349392-setting-maximum-field-value-100%25.html)

[email protected]

Setting a maximum field value to 100%

I'm calculating percentages... is there a way to set the maximum to
100% ?

That is, if the calculation were 130%, Excel would know to use 100%.
Is there a better way than an IF, THEN statement?

Thanks.

All times are GMT +1. The time now is 09:39 PM.