Spreed cost usig integral numbers (whole numbers)

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top