Calculating Incremental Percentages

[Scott]

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/com...5-13178abd0151&dg=microsoft.public.excel.misc

 

[Scott]

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

 

[Fred Smith]

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.