• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with dynamic range

B

bayofpigs

New Member
Hi all. I am having trouble with creating a dynamic range using the offset function as part of the fvschedule function. The purpose of using the fvschedule formula is to compute a compounding number.

I have attached a spread sheet for you to make sense of it better. My problem is when I have every section of the table filled in with dates it gives me an #REF error. But if I remove the last date it works and shows the compounding under the dates going across the spread sheet. How do I correct this?

Your help is much appreciated
 

Attachments

  • Book1.xlsx
    22.9 KB · Views: 12
Bayofpigs

Firstly, Welcome to the Chandoo.org Forums

I think N15: should be
=FVSCHEDULE(1,INDEX($E$22:$E$26,SUMPRODUCT(--($D$22:$D$26>=EOMONTH($N$9,0))),):INDEX($E$22:$E$26,SUMPRODUCT(--($D$22:$D$26>=EOMONTH(N9,0))),))
Copy across
 
Hi, thanks for your response. Unfortunately this does not work. The 1.02 is to begin Sept 2014 and prior to that it should be 1. We are in the same boat, this is the problem I am trying to solve.
 
You must log in or register to reply here.
Back
Top