User Profile
NelsonHorning
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
excel, rounding to a set sum
Hello, I have a question with excel. I am trying to do something that I cant figure out. I have 5 different people, trying to split 15 different things as equally as possible, percentage wise. Example: I order 50.....Bob order 30, jill order 75, ben orders 25, Jen orders 80. that comes to a total of 260. Now we together ordered 40 red, 25 blue, 100 pink, 50 green, and 45 black. Now we want to split that percentage wise, but it needs to hold out to whole numbers. I understand some have to round up and some down, so it wont be quite equal, but would there be a way to make it as equal as possible???560Views0likes0Comments
Recent Blog Articles
No content to show