here is what i'm looking to do..I want a cell to calculate the rate of return necessary to equal a certain amount found in a neighboring cell.
so in cell A31 is where i want my calculation to appear, in cell I3 i have the yearly contribution (this will stay the same for the 30 year calculation) and in cell J33 I've got the ending dollar amount.
so what i want to happen, if possible, is for cell A31 to calculate, based on the yearly amount contributed ( cell I3) and the ending dollar amount (cell J33) the rate of return necessary to achieve that end amount.
hope this makes sense, thank you so much in advance for your help!
Bookmarks