Hello,
I am looking for a way to distribute a whole number based on percentages and return whole numbers. For example, if I have a column of 4 percentages (A1: 38%, A2: 42%, A3: 16%, A4: 4%) that sum to 100% and want to distribute the number 3 according to those percentages it would return B1: 1, B2: 2, B3: 0, B4: 0.
Any help is very much appreciated, thank you!
Bookmarks