Share via

IRR function issue

Anonymous
2024-01-13T21:07:26+00:00

I am computing IRRs for different cash flows. I got the IRR for two of the columns without a problem. On one of the three columns I get a result of

#DIV/0! I have checked my numbers. They are essentially the same as the other two columns with some slight differences. Does anyone have an idea as to what is causing me to get that result instead of the IRR?
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-13T21:32:06+00:00

    See post above.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2024-01-13T21:28:18+00:00
    149 0 0 0
    150 38220000 31850000 25480000
    151 0 0 0
    152 0 0 0
    153 0 0 0
    154 0 0 0
    155 0 0 0
    156 0 0 0
    157 0 0 0
    158 0 0 0
    159 0 0 0
    160 0 0 0
    161 48377000 41466000 34555000
    162 1353702000 1,160,316,000 966930000
    1540755000 1463621000 1400336000
    2.88% #DIV/0! 3.18%
    34.53% 38.10%
    =IRR(B6:B168) =IRR(D6:D168) =IRR(F6:F168)

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. Dillon Silzer 60,931 Reputation points
    2024-01-13T21:10:28+00:00

    Is there any way you can give us an example of the data and the formulas?

    Was this answer helpful?

    0 comments