Search:

Type: Posts; User: kylc3; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: XIRR returns 0.00% instead of a negative percentage

    Thanks so much! One follow up question... I'm using this formula over rolling periods resulting in various outcomes, both positive and negative. Will this added parameter (-10%) be safe to use and...
  2. XIRR returns 0.00% instead of a negative percentage

    Hi,

    I'm running a savings scenario where the ending value of my investment ends up being less than the total contributions based on monthly returns during a down market period, but the XIRR is...
  3. Replies
    6
    Views
    3,531

    Re: XIRR with dynamic range

    Thank you! I'll give it a shot.

    This seemed to work as well... =xirr(m2:index(m2:m150,match("",i2:i150,)-1),i2:index(i2:i150,match("",i2:i50,)-1))
  4. Replies
    6
    Views
    3,531

    Re: XIRR with dynamic range

    Sorry, I tried to post a screen shot but it looks like it didn't work. Here's a link to a screenshot of the spreadsheet. Thanks!

    https://imgur.com/a/HR6ko
  5. Replies
    6
    Views
    3,531

    XIRR with dynamic range

    Hi,

    I work in the investment industry and am trying to calculate the XIRR of our various mutual funds using the dates and the monthly withdrawal amounts that change over time, with the ending...
  6. Replies
    1
    Views
    153

    Re: MEDIAN formula returning #VALUE! - Help!

    Anybody wanna take a stab at this one?
  7. Replies
    1
    Views
    153

    MEDIAN formula returning #VALUE! - Help!

    Hi!

    I'm using the following array formula to find the MEDIAN of a string of values:
    ...
  8. Replies
    6
    Views
    146

    Re: Min/Max/Average Arrays not working - HELP!

    dreid1011, you nailed it! Thanks so much!
  9. Replies
    6
    Views
    146

    Min/Max/Average Arrays not working - HELP!

    I have several sets of data that I'd like to be able to use the same array formulas for but I'm having an issue if the data set is not complete, meaning the range in the array formula is longer than...
  10. Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

    Very cool! Thx Marcelo Branco !!!
  11. Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

    Thanks for the heads up! I switched to your formula. I have an additional request posted above. Any chance you could help me out?
  12. Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

    Is it possible to get an additional formula that will count the total number of negative periods that the MIN is a part of? So, in my example, the total would be 10. I'm working with a very lengthy...
  13. Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

    Wow, that was fast! Thank you all for the feedback! I applied DRSteele's formula and it worked great! I need to build out some more functionality in the file, but first I'll have to figure out what...
  14. Find MIN within a range & count how many consecutive negative numbers until the MIN

    Let's say I have a column with the following values:

    ...
    -0.26%
    -0.09%
    0.00%
    0.00%
    -0.25%
    -0.82%
    -1.08%
Results 1 to 14 of 14