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