I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:

1000
1000
1000
450

I want this to repeat in as many cells as needed to get down to 0.

Any suggestions?

Assuming your number is in cell A1, and your "groups" continue down Column A.
In A2 enter:

=MIN($A$1*2-SUM($A$1:A1),1000)

Copy down as far as needed.

HTH,
Elkar


"Ooley" wrote:

I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:

1000
1000
1000
450

I want this to repeat in as many cells as needed to get down to 0.

Any suggestions?

With the number in A1
In B1 enter: =MIN(A1,1000)
In B2 enter:
=IF(MIN(ABS($A$1-SUM($B$1:B1)),1000)=0,"",MIN(ABS($A$1-SUM($B$1:B1)),1000))
copy down the column

But a VBA solution might be better if this is serious work.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Ooley" wrote in message
...
I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:

1000
1000
1000
450

I want this to repeat in as many cells as needed to get down to 0.

Any suggestions?

Try this:
A1 = 3450
B1 = 1000
C2 = MIN(B$1;MAX($A$1-(B$1*(COUNTIF(C$1:C1;"<")));0))
Copy C2 to other cells


--

Rodrigo Ferreira
Regards from Brazil


"Ooley" escreveu na mensagem
...
I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:

1000
1000
1000
450

I want this to repeat in as many cells as needed to get down to 0.

Any suggestions?