On Feb 9, 9:14 pm, b... / insecti.com wrote: > On Feb 9, 5:48 am, Alex Shulgin <alex.shul... / gmail.com> wrote: > > > Can we return 1/0.0 if NPV does not evaluate to 0 for a reasonably > > large IRR? > > > > irr([+100,+10,+10,+10]) > > => Infinity > > Such cases have an undefined IRR, and thus the behavior is undefined. Is it OK to format user's hard drive then? ;-) -- Alex