Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create a reference sheet to calculate a series of percentage
breakdown totals. For example, given a total of 5 divisions, I want to calculate 5 percentages, IN INCREMENTAL ORDER, that totals up to 100%. Now the number of divisions will be a set number, and all divisions will always add up to 100%. For example: 5 Divisions = 45%, 25%, 15%, 10%, 5% (maybe not those exact numbers, but something comparable.) Or for 3 divisions = 50%, 30%, 20% Any idea on how to accomplish this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating percentages in P&L | Excel Discussion (Misc queries) | |||
Calculating percentages | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages | Excel Discussion (Misc queries) | |||
Calculating percentages | Excel Worksheet Functions |