XIRR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble with this function. It does not seem to accept any valid date parameter, always returning a VALUE error. I have tried numerous options and even used the sample numbers from the function help, all with the same result

Does XIRR work

Office 2003 Professiona
Windows X

Best regards
Drew Yallop
 
Hi Drew!

It certainly does work! Check that all of your dates are dates and not
text. =ISNUMBER(A1) should return TRUE for all dates.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Drew Yallop said:
I am having trouble with this function. It does not seem to accept
Click to expand...
any valid date parameter, always returning a VALUE error. I have tried
numerous options and even used the sample numbers from the function
help, all with the same result.
 
Thanks Norman. That was the problem. Another has popped up however

I am populating an Excel sheet with data from a .Net dataset. The sheet contains the base data for another sheet that contains XIRR formulas, among other things. When .Net passes control of the workbook to the user, the XIRR formulas return !Name errors. If I try to enter an XIRR formula elsewhere the function does not appear in the function list. The Add-in dialog shows the Analysis toolpack as loaded

The only workaround I have found so far is to unload the analysis toolpack add-in, close the addin dialog, reopen the dialog and add the analysis toolpack again. The XIRR function then works

Any ideas

Best regards

Drew Yallo
----- Norman Harker wrote: ----

Hi Drew

It certainly does work! Check that all of your dates are dates and no
text. =ISNUMBER(A1) should return TRUE for all dates

--
Regard
Norman Harker MVP (Excel
Sydney, Australi
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments
available free to good homes
Drew Yallop said:
I am having trouble with this function. It does not seem to accep
Click to expand...
any valid date parameter, always returning a VALUE error. I have trie
numerous options and even used the sample numbers from the functio
help, all with the same result
 
Hi Drew!

Have you tried using:

Ctrl + Alt + Shift +F9

and

Ctrl + Alt +F9

But I've certainly not seen or heard of this problem before. It sounds
like a .NET specific problem.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Drew Yallop said:
Thanks Norman. That was the problem. Another has popped up however.

I am populating an Excel sheet with data from a .Net dataset. The
Click to expand...
sheet contains the base data for another sheet that contains XIRR
formulas, among other things. When .Net passes control of the workbook
to the user, the XIRR formulas return !Name errors. If I try to enter
an XIRR formula elsewhere the function does not appear in the function
list. The Add-in dialog shows the Analysis toolpack as loaded.
The only workaround I have found so far is to unload the analysis
Click to expand...
toolpack add-in, close the addin dialog, reopen the dialog and add the
analysis toolpack again. The XIRR function then works.
 
Thanks Norman. I will try the key combination and notify MS of the problem

Thank you for your help

Best personal regards

Drew
 
Hi Drew!

My suspicion is that you're importing data that looks like dates but
which aren't and that your numbers might have spaces and are not being
treated as numbers.

To make a successful report to Microsoft you must make sure that you
can replicate the problem. Preferably on different computers.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top