ahamilton613
New Member
- Joined
- Jan 10, 2018
- Messages
- 3
The FVSCHEDULE formula requires a single range of cells with the series of interest rates.
However, I need to build this series of interest rates through a dynamic formula.
Therefore I need a way to combine "[Formula 1]+[Formula 2]+[Formula 3]..." into a single range, or an expression that excel recognises in place of a single cell/range in the FVSCHEDULE formula (I have this issue quite a lot with different formulas).
I'm sure there is a simple solution, but the obvious solutions of arrays, conculcate, "&" etc didn't do it for me.
I don't think you need the full story, but if you are interested - I have a different interest rate for each year, I am trying to inflate a number but the start and finish date of the inflation period vary.
However, I need to build this series of interest rates through a dynamic formula.
Therefore I need a way to combine "[Formula 1]+[Formula 2]+[Formula 3]..." into a single range, or an expression that excel recognises in place of a single cell/range in the FVSCHEDULE formula (I have this issue quite a lot with different formulas).
I'm sure there is a simple solution, but the obvious solutions of arrays, conculcate, "&" etc didn't do it for me.
I don't think you need the full story, but if you are interested - I have a different interest rate for each year, I am trying to inflate a number but the start and finish date of the inflation period vary.