Whole #s as a result dividing by 3

[Russk68]

Hi All
I want to divide a number by 3 and distribute it in whole numbers. I found examples online using a bucket and tennis balls but haven't been able to translate it.

A1=22 tennis balls, and B,C,D are buckets of tennis distributed into whole numbers
B1=8
C1=7
D1=7

Your help is greatly appreciated!

 

[alansidman]

maybe this:

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][/tr]
[tr][td]

1​

[/td][td]

22​

[/td][/tr]


[tr][td]

2​

[/td][td]

=MOD(A1,3)+INT(A1/3)​

[/td][/tr]


[tr][td]

3​

[/td][td]

=INT(A1/3)​

[/td][/tr]


[tr][td]

4​

[/td][td]

=INT(A1/3)​

[/td][/tr]
[/table]

 

[Russk68]

That works great! It's so much simpler than what googled.

Thank you very much!

 

[Russk68]

Hi Alan,
Thank you for your help on this. I just realized that a remainder of 1 works great for me but a remainder of 2 doesn't and was wondering if you could tweak you formula. The top example is how it works. The bottom is what I'm looking for.

A1=47
B1=17
C1=15
D1=15

A1=47
B1=16
C1=16
D1=15

Thanks!

 

[Peter_SSs]

If you could leave B1 empty and put your results into C1:E1, then you could use this formula, copied across.
Column B could be hidden if you want.

Excel Workbook
	A	B	C	D	E
1	47		16	16	15
Divide into 3

 

[Russk68]

Awesome!
Thank you Peter!

 

[Rick Rothstein]

Here is another "single formula" solution for you to consider. With your number in cell A1, put this formula in cell B1 and copy across to cell D1...

=INT($A1/3)+(MOD($A1,3)>=COLUMNS($B:B))

 

[Peter_SSs]

Awesome!
Thank you Peter!

You are welcome.
Rick has a good one for you too that doesn't require the extra column like mine.