XIRR Function - #NUM error
On Tue, 8 Jul 2008 17:01:16 +0200, "Niek Otten" wrote:
All dates must be later than the first one. You have the same date for 1st and 2nd.
I know it says that in the HELP section , but this sequence, with the same date
for 1st and 2nd, does not give an error. The #NUM! error may be due to the
absence of an appropriate Guess.
5-Jan -10000
5-Jan 5000
10-Jan 5000
31-Dec 5000
--ron
|