Divide a number into multiple cells

[beitzy]

Hi,

Im looking for a formula that will divide a whole number over multiple cells.

For example;

the whole number needs to be divided by 45 with the remainder displayed in the next cell.

It should like this, e.g. A1 (user input) 108, A2 45, A3 45, A4 18.

The number in A1 may be as large as 450, so the formula would have to spread over 10 columns.

Appreciate your help

Thanks

[Pete_UK]

Put this in B1:

=IF(INT($A1/45)>=COLUMNS($B:B),45,IF(COLUMNS($B:B)>INT($A1/45)+1,"",MOD($A1,45)))

then copy across as far as you need to.

Hope this helps.

Pete

[bebo021999]

With A2 = 45
B1:=MIN(A1,$A$2)
C1=MIN($A$1-SUM($B$1:B1),$A$2)
Drag C1 across as far as you need.

[Fotis1991]

Another way..

In B1

Please Login or Register  to view this content.

In C1 and copy across.

Please Login or Register  to view this content.

[beitzy]

Thanks for your quick replies, the methods you both supplied work great.
I appreciate your help.