Divide a number into multiple cells

I need to divide a number into multiple cells accurately. All results should
equal the divided number if summed.
An odd number for example;
455 divided into 4 cells should return 114, 114, 114, 113.

Or an even number;
424 divided into 4 different cells returning 212, 212, 212, 212.

Thanks

The question is do the numbers have to be rounded up or down to whole numbers
or can they be decimals?

If 455 was in cell A1 you could copy this forumla into four cells =$A$1/4
which would give you 113.75, a sum of those 4 cells = 455

"rhon101" wrote:

> I need to divide a number into multiple cells accurately. All results should
> equal the divided number if summed.
> An odd number for example;
> 455 divided into 4 cells should return 114, 114, 114, 113.
>
> Or an even number;
> 424 divided into 4 different cells returning 212, 212, 212, 212.
>
> Thanks
>

Hi!

It looks like you want whole numbers as results.

What result would expect from 286?

72....72....72....70 = 286

A1 = some number

Enter this formula in B1 and copy across to E1:

=IF(COLUMNS($A:A)<4,ROUND($A1/4,0),$A1-ROUND($A1/4,0)*3)

Biff

"rhon101" <[email protected]> wrote in message
news:[email protected]...
>I need to divide a number into multiple cells accurately. All results
>should
> equal the divided number if summed.
> An odd number for example;
> 455 divided into 4 cells should return 114, 114, 114, 113.
>
> Or an even number;
> 424 divided into 4 different cells returning 212, 212, 212, 212.
>
> Thanks
>

This is a great formula. I am trying to adapt it for for 12 columns with any smaller numbers (if needed) generated first.
E.g. 14 as the total number with columns B-N displaying the breakdown. Columns B-K would display 1 and columns L-M would display 2.
Any help gratefully received.

BW
Bryan

PS the series of numbers I want to use as totals are: 12, 14, 16, 26, 28, 30 & 42
Thx Bryan

Found the solution in "Dividing a number so that there is no remainer but total is the same"
Many thanks
Bryan