Escalating payments with changing rates.

[zumbito]

Hi everybody, I am going from problem to problem.

I am trying to scalate payments through a column. Problem is there is an inflection point along the column where formula interest rates to apply vary, this point also varies depending when I get a 0 in the next column.

Before there was a single interest rate and single formula it was fine (payment)*(1+interest rates)^(current year-beginning year in absolute reference) and drag it all down. Will give me the price escalation through the years.

Problem is now with a interest change down the line, the first row as an absolute reference only works before the interest change. After the change, I need to find out the difference between the year of the payment I am trying to calculate and first year after interest change, and this date of the change will change depending on the inputs of the problem.

Basically the column has to find the 0 value in the next column and apply a different formula up and down from there.

Any ideas how to solve this?

[zumbito]

Anyone can help? My model is stuck, I tried to Google, but everything under "splitting column" refers to splitting it into two columns not in two ranges.

[JeteMc]

Please upload a sample that demonstrates the issue. Show the results that the formula produces then, manually, show us what you want/expect to be produced. We may then be able to replicate the results that you want using formulas/code.
To upload a sample workbook/spreadsheet (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[zumbito]

Here you have, the problem is with the red cells. Blue row marks the point were the formulas should change.
Hope this explains it better.

[JeteMc]

See if the following, pasted into F7 and copied down, yields the expected results:

Please Login or Register  to view this content.

If not please let us know the values you expect to see in F42:F43.
Let us know if you have any questions.