This could be a little hard to explain, but I'll try and if needed, attached is a sample.
The number in D2 represents number of employees.
In D4/D5 the number of employees is multiplied by the corresponding percentage to get the number of employees within that section. Section 1 has employees A and B.
In E4/E5 I need a whole number for that group of employees, but within each section, any residual would fall to the second group (so any default would roll to employees B).
For scenario 1, in the end, the total number of employees would need to be 313.
Is there a good way to do this?
Bookmarks