dividing a number up evenly into a year
In A1 enter 17 (value to be distributed)
In A2 enter 12 ( the number of months)
In B1 enter:
= ROUND(ROW()/$A$2*$A$1,0)
In B2 enter:
= IF(ROW()<=$A$2,ROUND(ROW()/$A$2*$A$1,0)-SUM(B$1:B1),"")
and copy down.
In A1 thru B12 we now see:
17 1
12 2
1
2
1
2
1
1
2
1
2
1
Have a Great Day!
--
Gary''s Student - gsnu200856
"jxbeeman" wrote:
Hi,
I've been trying to make a formula that divides any whole number up into a
year based on the current month. Let me explain with an example.
Number to divide 17
Result:
month-- 1 2 3 4 5 6 7 8 9 10 12
Divided number-- 1 1 2 1 1 3 1 1 2 1 2
so the divided number still sums up to 17 but is evenly distributed through
the year even though it is an odd #. Any help/Ideas would be greatly
appreciated.
Thanks,
Josh
|