That's what the #num is telling you. I am using Excel 2007 on Windows 7. Second, and more significantly, I said that the number of sign changes was not "necessarily" the answer -- as in "necessary and sufficient" -- as you seemed to imply. Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What

The following sequence of cash flows without a guess rate will produce an answer of 25%. As you point out in your second response, it all depends on how close the (default) "guess" is to any one of the solutions. Developing web applications for long lifespan (20+ years) What advantages does Monero offer that are not provided by other cryptocurrencies? If IRR gives the #NUM!

This documentation is archived and is not being maintained. Hot Network Questions Can Communism become a stable economic strategy? Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not I can't : figure out why.

A formula results in a number thatâ€™s too large or too small to be shown in Excel. All rights reserved. Yes No Additional feedback? 1500 characters remaining Submit Skip this Thank you! Excel shows this error when a formula or function contains numeric values that arenâ€™t valid.

Post a question in the Excel community forum Help us improve Excel Do you have suggestions about how we can improve the next version of Excel? ExcelFunctions.net Search Site: + Home » Excel-Built-In-Functions » Excel-Financial-Functions » Excel-Irr-FunctionExcel IRR Function Related Functions:NPV FunctionMIRR FunctionXIRR FunctionInternal Rate of ReturnThe Internal Rate of Return (IRR) provides an indication of the How can we improve it? If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

After doing a little troubleshooting, I was curious to know at what point did it throw the #NUM error rather than the actual IRR %. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

A1=-1064000 A2=272564 A3=IRR(A1:A2) ---> -74% Share Share this post on Digg Del.icio.us Technorati Twitter Work: Windows 7 / Excel 2013 Home: Windows 7 / Excel 2007 Reply With Quote Mar 8th, All contents Copyright 1998-2016 by MrExcel Consulting. For example: =IRR(D4:D8, -5%) This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range. All rights reserved.

IRR (Office Excel 2003) had no trouble computing the rate (20.13% per period) for the second cash flow. More... share|improve this answer answered Sep 3 '13 at 2:09 Pieter Geerkens 1308 add a comment| up vote 0 down vote Internal Rate of Return calculates the discount rate for an original Since the Excel IRR (as all are) is a numerical root finding technique, it produces only one answer, if it can find it, that is closest (in an algorithm sense, since

Here is the FAQ for this forum. + Reply to Thread Results 1 to 8 of 8 #NUM errors when calculating IRR Thread Tools Show Printable Version Subscribe to this Thread… error when: A formula uses a function that iterates, such as IRR or RATE, and it canâ€™t find a result. What will be the IRR?Thank you Our Company Sharon Parq Associates, Inc. Please try the request again.

Logical fallacy: X is bad, Y is worse, thus X is not bad Can two integer polynomials touch in an irrational point? Microsoft Excel uses an iterative technique for calculating IRR. If you need to, you can adjust the column widths to see all the data. please give it any solutiuon Barb11 May 2014, 12:49 Don - I think you need the XIRR function as followsput the dates in B1 - B51 Jan 14, 1 Jan 34

ExcelTips is your source for cost-effective Microsoft Excel training. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 8th, 2013,08:46 PM #6 NickRizz New Member Join Date Mar 2013 Posts 4 Re: IRR giving #NUM error Revenue inputs will be $410 at each 20yrs, 40yrs, 60yrs, 80yrs. Take the following cash flows: -28.00 53.00 -8.00 Two sign changes, therefore there can be 0, 1 or 2 roots Find the IRR using Quadratic Formula -28+53/(1+r)^1-8/(1+r)^2=0 Multiply through by (1+r)^2

Why did it take 10,000 years to discover the Bajoran wormhole? (KevinC's) Triangular DeciDigits Sequence Does the recent news of "ten times more galaxies" imply that there is correspondingly less dark Your feedback about this content is important.Let us know what you think. the periods are evenly spaced but the project throws off some irregular cash flows... asked 3 years ago viewed 1296 times active 3 years ago Related 1Applying Excel formula to a large column2Formula error while counting unique entries in Excel0Why am I getting a “name

Any other feedback? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. I assume the cash flows read left-to-right, top-to-bottom. Why are so many metros underground?

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. We appreciate your feedback. To fix this, change the number of times Excel iterates formulas: Click File > Options. Send No thanks Thank you for your feedback! × English (United States) Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Sign in Search

You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using the IRR Function. IRR uses the order of values to interpret the order of cash flows. More... In the Maximum Change box, type the amount of change youâ€™ll accept between calculation results.

As for the first and third cash flows, IRR computes the rate at which the NPV is zero. A formula results in a number thatâ€™s too large or too small to be shown in Excel. We appreciate your feedback.