View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default IRR Function Error Messages

On Fri, 7 Sep 2007 10:52:03 -0700, ChillChameleon
wrote:

Thanks, Ron. Changing the guess helped for most of them, including some of
the DIV/0s. Unfortunately the auditing tool (trace error) hasn't helped as
there doesn't appear to be anything in the preceding formulas to generate a
problem.

Appreciate the tip.

CC


Glad it helped. If you aren't getting any help from trace with the DIV/0
errors, then those, too, are probably being caused by an inappropriate guess.
--ron