View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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