Try ...

={-NPV(Rate,max(SIGN(CF),0))/NPV(Rate,(Min(SIGN(CF),0)}

I think using max and min is much more faster then the if statement.

Samo ... good luck


--
Samo
------------------------------------------------------------------------
Samo's Profile: http://www.excelforum.com/member.php...o&userid=34413
View this thread: http://www.excelforum.com/showthread...hreadid=541868