Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom range in formula (2000)

    I have some IRR formulas in a spreadsheet. Eg "=IRR(B1:B145,0.1)
    I want to be able to change the end-range of the formula by entering a number in a cell A1. Eg. If I entered 60 in cell A1 the formula would switch to "=IRR(B1:B60,0.1).

    I'm sure this should be fairly simple, but I cant quite figure it out !
    Any help much appreciated.

    Thanks
    Rob

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom range in formula (2000)

    Try:

    <code>
    =IRR(INDIRECT("B1:B"&A1),0.1)
    </code>
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom range in formula (2000)

    Thanks Legare
    That does the trick!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •