Thread
:
Setting a maximum field value to 100%
View Single Post
#
1
Posted to microsoft.public.excel.programming
[email protected]
Posts: n/a
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.
Reply With Quote
Setting a maximum field value to 100%