Spreding a number wholly and equally over a fixed number of cells

Welcome to the forum.

Your last sentence suggests that you are offering payment: this is a free forum, so that will not be allowed. If you want to pay someone to complete a big project for you, we have the Commercial Services section. However, I'm not sure this is a big project.

Whoever helps you will explain the solution if you want - that will be free as well!

Where in your attachment have you mocked up the results you are aiming for?

Something's gotta give - unsure what your preference is. Part of the problem is that you want this spread 'evenly' over 24 periods - except the last one - which could cause some problems.

You could just round the number, but as you are experiencing, you could send everything well before the 24th (or even the 23rd) shipment, or you could have a rather large 'catch-up' shipment at the end.

You could use FLOOR, instead of ROUND, which would mean you have a larger final shipment.

Personally, I would try to have a somewhat even distribution and would use a formula like this:
C14: =FLOOR(C5/24,1)
C15: =B7-C14
D14: =FLOOR(C15/(24-COLUMN(A:A)),1) then drag to column Z
D15: =C15-D14 then drag to column Z

Not sure how you want to handle the remainder. You could change Z14 to:
=ROUND(Y15/(24-COLUMN(W:W)),0) if you want to just round (which could mean you sometimes ship more and sometimes less than what was paid for)
or
=Y15 if you can ship non-whole numbers

Hi -

I just made a few simple modifications to your spreadsheet:

1. The formula Row 7 was hard coded to divide the Total Owed Amount (cell B7) by 24. I changed that to =$B$7/$C$4. That way you can change the number of months in cell C4 and it will recalculate the monthly shipment.

2. The Balance, in Row 9 was taking the previous months balance and subtracting the rounded amount, not the Quantity to Deliver. That was one of the reasons you were getting negative numbers at the end. So, I changed that formula to subtract the actual delivered amount from the previous balance. That formula looks like:

=C9-D10

3. Finally, instead of just putting the rounded amount in the Quantity to Deliver, I added an IF() statement to check and see if the previous months balance is less than or equal to the monthly, rounded shipment amount. If the remaining balance of the previous month is less than the rounded amount to ship, it just uses whatever amount is left over. That formula looks like this:

=IF(C9<=D8,C9,D8)

I have attached your modified spreadsheet.

Hope this helps.