View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default disperse amount across multiple cells without fractions

Here's one way.

In my example, I put in A1 the number to be divided up, say
8.92307692307692.

To divide it into four parts,
In B1 put: =ROUND(A1/4,1)
In B2 put: =B1
In B3 put: =B1
In B4 put: =ROUND(A1,1)-SUM(B1:B3)

Modify to suit the need.