Hi,
I dont know how to use VBA, but need a formula that does an automatic goal seek. I need to eliminate the rounding errors in excel IRR by using NPV.
In the Attached I want to make NPV =0 by changing the Rate automatically. (see attachment for more info) its really tiny changes but effects large amounts.
Thanks..
Bookmarks