View Single Post
  #5   Report Post  
Dkline
 
Posts: n/a
Default IRR Guess Problem

I remember Lotus 123. Use to use it every day until Excel became a better
product. Thanks for your help.

"Harlan Grove" wrote in message
...
"Dkline" wrote...
It works. But why does it work?


It works because it forces Excel to search through a much wider initial
range of interest rates. As for why they didn't use this as the default
initial value, I'd guess it was for compatibility with Lotus 123 back a
couple of decades ago.