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" wrote in message
...
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