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)