View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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