Dividing an odd number into three.

[haylleyjo]

Hi all --- I'm looking for a function (or formula) that will divide a number (for example, 580) into three whole numbers that a) don't have decimal points and b) actually add up to 580. Eg 580 = 193 +193 + 194. I can't seem to find anything. All of the "ROUND" formulas give me an answer along the lines of 580 = 193 +193 + 193 (which is incorrect).

Does anyone have any ideas? Any help with this would be much(!!) appreciated.

[djapigo]

Try this...

if A1=580
Then B1=int(A1/3)
B2=int(A1/3)
B3=A1-B1-B2

re-post: you can also use ROUND instead of INT for the first 2 formulas...

[tigeravatar]

haylleyjo,

Welcome to the forum!
The easiest solution is actually two different formulas. Use the Round(#/3,0) for the first two numbers, and the 3rd number should get the remainder with #-Sum(), like so:

Number to divide:	580
1st #	193	=ROUND($B$1/3,0)
2nd #	193	=ROUND($B$1/3,0)
3rd #	194	=B1-SUM(B3:B4)

[haylleyjo]

Wow. Thanks so much y'all! That is such a great solution. Works perfectly.