View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m
 
Posts: n/a
Default Divide a number into multiple cells

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