Calculating Incremental Percentages
Is there a way to calculate incremental percentages? For instances, needing
3 numbers, I want to calculate and list incremental percentages like 50-30-20, where numbers start larger and get smaller. All percentages must add to 100%. For 2 numbers, 60-40, and so on. Is this possible? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Calculating Incremental Percentages
Sorry, this is meant to be a question, not a suggestion.
|
Calculating Incremental Percentages
Anything is possible if you can define the problem. Is the starting
percentage a given? What's the relationship among the three numbers, other than the fact they have to be smaller than the preceding one? Regards, Fred. "Scott" wrote in message ... Is there a way to calculate incremental percentages? For instances, needing 3 numbers, I want to calculate and list incremental percentages like 50-30-20, where numbers start larger and get smaller. All percentages must add to 100%. For 2 numbers, 60-40, and so on. Is this possible? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com