Spread a value proportionally across several cells (with rounding)

this is not an Excel question as much as a math question. I don't see how to do your magic distribution because I don't see any rule(s) you used. For example if you replace 1-6 all with 4.5 then the total is 27 and the 25% rounded up is still 7. So the 25% of each value is 1.125 so how would you propose to distribute the 7 across the 6 values in that case? If you can explain a fixed rule we can tell you how to make it is Excel but without those rules I don't see a way. I could propose that you round up until you can't anymore so basically in my example all of them round to 1 but then you have 1.0 left over so the 1st 2 would be 1.5 and the rest 1.0. but in your example I couldn't see any rules to apply