Hello,
I have figured out how to allocate the cost across the different months but I want the very next cell in the array to have a different calculation based sum of the array. I am sure that I am not explaining this well. Example: I want the number in a cell (say 200,000) to be allocated over duration indicated in a cell (duration 7) then the very next cell (8th month) to but the sum of the 7 months array subtracted from the cell holding the 200,000.
Here are my formulas:
=IF(COLUMNS($R68:R68)>$P68,"",($I68*0.64/$P68)) This is in the first 7 cells
=I68-(SUM(R68:V68)) this is in the 8 cell
Is there a way to combine this so it would be automatically calculated no matter what the duration number is.
Bookmarks