how do you divide the average of a number into 3 different cells.

i am trying to do a stock and order for work. i have to divide the amount of
sales by the quantity of units in a case to come up with ( cases required to
order). i have done that but i need to average that total into to three
cells. e.g 12 = 4 4 4, 11 = 4 4 3

Assuming you want the last column to be the "catch" column, that is it
will either be higher or lower than the other two columns by one if the
number is not divisible by three evenly you can try the following:


Code:
--------------------
Row Col A Col B Col C Col D
11 11 =MROUND(A11,3)/3 =MROUND(A11,3)/3 =MROUND(A11,3)/3-(MROUND(A11,3)-A11)
12 12 =MROUND(A12,3)/3 =MROUND(A12,3)/3 =MROUND(A12,3)/3-(MROUND(A12,3)-A12)
13 13 =MROUND(A13,3)/3 =MROUND(A13,3)/3 =MROUND(A13,3)/3-(MROUND(A13,3)-A13)
--------------------


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=564899

On Tue, 25 Jul 2006 21:44:02 +0100, Shaun
wrote:

i am trying to do a stock and order for work. i have to divide the
amount of
sales by the quantity of units in a case to come up with ( cases
required to
order). i have done that but i need to average that total into to three
cells. e.g 12 = 4 4 4, 11 = 4 4 3

don't use the word average - confusing.

You want to split or spread

if A5 = 12
then B5 = roundup(a5/3,0)
c5 = roundup(a5/3,0)
d5 = a5-b5-c5

This gives odd result for 10, ie 4,4,2
and for 9 result is 3,3,3

If this is acceptable
otherwise
change c5 = roundup((a5-b5)/2,0)
not 10 produces 4,3,3



--
Steve (3)