Thomas Kuriakose
Active Member
Respected Sirs,
We have a scenario to calculate percentage cap to not exceed 100%.
a) The values in range G9:G13 are based on the cap with round not to exceed 100%.
b) The values in J9:K13 are based on normal percentage of total without round. These values when copied to an external software total upto 101%.
The solution in a) works when copied to external software. However the apportionment is not distributed as per requirement. if we need to get an option to change values in G11, G12, G13 from 3%, 2% and 3% to 3%, 3% and 2% respectively, or any other proportion, how can we achieve this.
Kindly find attached the file your kind perusal,
Thank you very much.
with regards,
thomas
We have a scenario to calculate percentage cap to not exceed 100%.
a) The values in range G9:G13 are based on the cap with round not to exceed 100%.
b) The values in J9:K13 are based on normal percentage of total without round. These values when copied to an external software total upto 101%.
The solution in a) works when copied to external software. However the apportionment is not distributed as per requirement. if we need to get an option to change values in G11, G12, G13 from 3%, 2% and 3% to 3%, 3% and 2% respectively, or any other proportion, how can we achieve this.
Kindly find attached the file your kind perusal,
Thank you very much.
with regards,
thomas