N
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.
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.