View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rhon101
 
Posts: n/a
Default 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