Forum Discussion
Distribute a number in a cell on multiple cells
See the attached demo workbook.
Not to dispute the method used by my friend HansVogelaar , but to point out that the key word you have used--equal--as in your statement "I want to distribute this amount on each item equally," can be taken in two different directions. I've attached a revised version of the spreadsheet here to show it. To be clear, I agree with the method HansVogelaar used, I think it's the more reasonable approach.
Nevertheless, one could also have taken those extra charges, amounting to 537 Euros, and divided that amount by 10, and distributed 53.7 Euros equally to each of the ten product lines, getting results that differ from the proportional distribution.
Now I have the two methods. The second method is more accurate if I need to distribute the total expenses equally on each item’s unit price.
Thank tou very much
