Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Incremental Percentages
Sorry, this is meant to be a question, not a suggestion.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percentages in P&L | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Worksheet Functions | |||
Calculating percentages | Excel Worksheet Functions | |||
calculating percentages | Excel Worksheet Functions | |||
calculating percentages | Excel Discussion (Misc queries) |