ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating Incremental Percentages (https://www.excelbanter.com/excel-discussion-misc-queries/235258-calculating-incremental-percentages.html)

scott

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

scott

Calculating Incremental Percentages
 
Sorry, this is meant to be a question, not a suggestion.

Fred Smith[_4_]

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