I had this document working in excel 97 but I cant get my head around the excel 2010 solver.
I am trying to match a cell to a target cell by changing another cell which is running an XIRR formula. i.e. trying to work out the purchase price of something to achieve an XIRR.
I have attached a trial book. I have no idea what to put in the new 2010 cells for the solver parameters!!
Many thanks for any help in advance!
Alex
Bookmarks