User Profile
Kazz84
Copper Contributor
Joined Jan 04, 2021
User Widgets
Recent Discussions
Re: Divide a quantity as whole number among multiple cells
I've been looking all over the internet trying to find a solution to my problem and this post seems to be on the right track but does not quite get to the necessary answer I am looking for. I need to divide a whole number into 5 columns with a maximum of 3 in each column apart from column 5 which can be the remaining number of whole numbers, Example: The whole number is 20 Column A 3 Column B 3 Column C 3 Column D 3 Column E 8 Is there a formula that can help me achieve this? I would be sincerely grateful for any assistance. Remya Ramakrishnan80KViews0likes41Comments
Recent Blog Articles
No content to show