Spreed cost usig integral numbers (whole numbers)

[nils]

Hi.
I am making a budget, and have the following problem. I have estimated an
annual cost for each account in cell B as a whole number, and would like to
have a formula that spreads the cost as equally as possible over the next 12
columns’ (each columns represents a month) by using whole numbers.

If I have estimated an annual cost of 13, the cost should be 1 in 11 months
and 2 in one month. Herby adding up to 13.

 

[Eduardo]

Hi,
assuming your total cost is in column A

for the eleven months enter

=round(A1/12,0)

in the 12 month column

=A1-sum(B1:L1)

if this helps please click yes thanks