Address 1049 Main St, Mount Desert, ME 04660 (207) 244-8007 http://www.cscmdi.com

# excel 2010 xirr num error Corea, Maine

Ask Your Own Question Calculate Function (xirr) On Filtered Data - Excel Excel Forum Hello, I have a database of transaction information in a spreadsheet with Filters in place. It's no problem totaling the numbers in the 2 groups, but I can't figure out how to include the value of the positive numbers in B14 and negative numbers in B15 The solution, clearly, is to stop using EXCEL for important calculations like this and start doing this in SQL Server using XLeratorDB. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search

In the exampl Delete Empty Columns - This macro will delete columns which are completely empty. You can find the Microsoft documentation here. Ask Your Own Question Yield Vs Xirr Discrepancy - Excel Excel Forum I input the following information for a standard semi-annual 30/360 bond and calculated the Yield. Note that the exact binary representation of -79.29402041327662% must be entered using VBA CDbl("-0.7929402041327662").

like so: See the calculation in Figure 1? Thanks again! Using a binary search algorithm, I determined that about -79.29402041327662% causes the sum of the discounted cash flows to be about zero [1]. Generated Sat, 15 Oct 2016 09:40:56 GMT by s_ac15 (squid/3.5.20) Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Worksheet Functions > XIRR #NUM error

no input or a text entry was entered), when they click OK. There's nineteen rows of data. Hmmm ... error value.

Would love a formula to handle this for me! It ain't MY fault. d1 = the 0th payment date. Just a microscopic change in the initial investment changes the XIRR response.

Example... Let me know if you have any other questions - thanks! Thanks... Discussion in 'Microsoft Excel Worksheet Functions' started by aa, Oct 11, 2010.

Wrong! Another example is monthly cash-flows with incomes and spendings. Clearly it is something to do with trying to use the "less than or equal to" with the negative number that is causing a problem. Possible cause: Suggested action: Using an unacceptable argument in a function that requires a numeric argument.

Is there a way to do this? I have been advised previously to use a formula in another cell and hide it etc, but for my purposes, this is not the preferred option. In the values provided to the function, you enter payments you make as negative values and income you receive as positive values. that's left as an exercise, for you.

Have you forgotten? Error bars allow you to show the potential variance ... Right now, I have =COUNTIF(\$V\$1:\$V\$57,"<0") to count the number of times there are negative values, and ">0" to count the positive values for each column. Any help would be greatly appreciated.

Michael Ask Your Own Question Separating Positive And Negative Numbers? - Excel Excel Forum Hi, say I have a column of data. Description Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. If you're having a computer problem, ask on our forum for advice. And my result is #NUM!.

Recently we received a support request from a customer wanting to know why EXCEL’s XIRR function was returning a different result from the XLeratorDB XIRR_q function. any help is appreciated. > using excel 2003 > > 17-Aug-10 178200 > 18-Aug-10 -5329800.11 > 18-Aug-10 184500 > 18-Aug-10 300000 > 18-Aug-10 -4881000.14 > 18-Aug-10 -4562099.88 > 20-Aug-10 -5273100 > This is real estate related, so it's an original purchase price, then contributions and distributions, and eventually a sale (reversion). Learn more about Allen...

The higher the number of iterations, the more time Excel needs to calculate a worksheet. If so, please check out the topics at Excel User Voice See Also Overview of formulas in Excel How to avoid broken formulas Use error checking to detect errors in formulas I then calculate a XIRR function on filtered data. Click Show Calculation Steps if it’s available, and pick the resolution that works for your data.

Is anyone able to advise me on the code to use for this function, as I would love to be able to have this working to make my spreadsheet more foolproof. For example, an array formula that will only calculate xirr if a column meets a certain criteria or if the dates are within a range? If you picked a good guess you got a close enough answer in 5 iterations and it you didn't, you may never get an answer. Register To Reply 02-09-2011,02:08 PM #6 kevwags View Profile View Forum Posts Registered User Join Date 02-09-2011 Location Newport Beach, CA MS-Off Ver Excel 2010 Posts 4 Re: XIRR and IRR

error value occurs when a problem occurs with a number in a formula or function. > Possible cause: >     Suggested action: > > Using an unacceptable argument in a Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Typically I calculated series that stacked separately the + and - terms, as well as the total. Is there a way to force Excel to ignore rows hidden by the filter criteria?

See http://office.microsoft.com/en-us/ex...001124595.aspx I'm wondering if the answer to your problem is to "Make a Better First Guess"? To calculate the internal rate of return for a series of periodic cash flows, use the IRR function. The other is done using 37 total flows, the first being entry and the other 36 being monthly flows with the mirr rate being multiplied by 12 to get an annualized