Just check your formula in A3 to A9 again - it looks like you have
=$A2-2 for it to give you 45 in those cells.

In your original post, you said you wanted to split the number into 6
cells, whereas you now quote 47 split into 4 - is the number of cells
variable, and if so, where (which cell) would this be located?

Pete

Dos Equis wrote:
Thanks guys, that function helps, but it's returning incorrect data.
If $a2 is 47, $a3-9 return 45 and the sum in $a10 is 270. Not what I
was looking for. Should have ended with 12,12,12,11 in the first 4
cells and totaled 47 in $a10

It does give me something to work with though so thank you. If you
have any other ideas, I'll still be checking this post..

Thanks again,

Byron

Pete_UK wrote:
Just a slight tweak - use:

=ROUND($a2/6,0)

Hope this helps.

Pete

Marcelo wrote:
hi

assuming the 65 is on the a2

on b2 use:

=$a2/6
copy it util f2
and on g2 use a2-sum(b2:f2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dos Equis" escreveu:

Hi,

Does anyone know how to divide the number in one cell and have up to 6
other cells equal the original number? i.e. 65 = 11, 11, 11, 11, 11,
10.

Thanks for any help

Byron