Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: XIRR formula

  1. #1

    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have the following formula :-

    =ROUND((XIRR({-198567.26,4750,204032},{36257,36295,37315},0.1)*100),2)

    How can it be re-written so that the figures 204032 and 37315 can be replaced by cell refs ?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-23 00:16, Amds wrote:
    I have the following formula :-

    =ROUND((XIRR({-198567.26,4750,204032},{36257,36295,37315},0.1)*100),2)

    How can it be re-written so that the figures 204032 and 37315 can be replaced by cell refs ?
    Constants of a constant array cannot be variablized, that is, replaced with cell refs. It seems you want to experiment with defferent values. I'd suggest placing the values in your constant arrays in columnar ranges of their own, which you can change at will:


    =ROUND((XIRR(A2:A4,B2:B4,0.1)*100),2)

    where A2:A4 houses the values

    -198567.26
    4750
    204032

    and B2:B4 the date values

    36257
    36295
    37315

    formatted as date.



  3. #3

    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks.
    That's what I thought ("Constants of a constant array cannot be variablized, that is, replaced with cell refs") .... but was hoping it was possible.
    I suppose I'll just either have to rearrange my data so as to be able to use cell refs for all, or live with all hard values in the formula.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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