Hi All,
I try to do something but cannot find the solution - so i turn to you for help.
In Cell A1 there is a low number (from 1 upto 30) - (number of systems)
In Cells B1 to B10 - 10 percentages that sums to 100% - for example - 40%,20%,20%,20%,0%,0%,0%.... (allocation per region)
I need to allocate those systems per region, but i cannot have 0.X systems.. so only integer/full numbers. (in cells C1 to C10)
Logic says that if for example the system count is 2, and the percentages are as above, then Region 1 (40%) will get 1, and the next region (20%) will get 1. all others (even the other 20%) will have 0.
or if the system count is 6, 40% will get 3, all other 20% will get 1 each.
Is there a way to do that without VBA? only with pure formulas?
thanks
I try to do something but cannot find the solution - so i turn to you for help.
In Cell A1 there is a low number (from 1 upto 30) - (number of systems)
In Cells B1 to B10 - 10 percentages that sums to 100% - for example - 40%,20%,20%,20%,0%,0%,0%.... (allocation per region)
I need to allocate those systems per region, but i cannot have 0.X systems.. so only integer/full numbers. (in cells C1 to C10)
Logic says that if for example the system count is 2, and the percentages are as above, then Region 1 (40%) will get 1, and the next region (20%) will get 1. all others (even the other 20%) will have 0.
or if the system count is 6, 40% will get 3, all other 20% will get 1 each.
Is there a way to do that without VBA? only with pure formulas?
thanks