software

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.

ThanksThe 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

quot;rhon101quot; wrote:

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

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)lt;4,ROUND($A1/4,0),$A1-ROUND($A1/4,0)*3)

Biff

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