Divide a number into multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top