• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Solving for a number value

P

pauldurso

New Member
I am an avid excel user but I can seem to figure this formula out. I want to solve for a value. I have attached an excel file so you can see what I am referring to.


http://dl.dropbox.com/u/19969657/solve.xlsx


M7 is the cell that changes all of the numbers on the page and that is the cell I would like the formula to figure out. I am running an income analysis that runs a client to their age 95. I would like a formula in cell M7 to solve for cell I47 to equal zero. The answer is between 1.99% and 2.00%


I know I can use the "what if" and "solver" to figure it out for me, but I am looking for a formula to automatically do that for me.


Anyone have a suggestion?
 
Hi Pauldurso,


Welcome to the forum!! The diff. you are talking about is so small that i am unable to get it even manually!! hehehe


Regards,
 
Hi, pauldurso!

I think that even if you could construct an inverse formula to go from I47 as input to M7 as output (e.g., formula for M7: =function(I47,othercell1, othercell2, ...)), it'd be impossible to avoid the circular reference issue, since I47 it's M7 dependent.

That's one of the whys because Solver was implemented into Excel.

Regards!

PS: Just in case, for Solver do this:

Change format of cell M7 from 2 decimal places to 4.

Go to Solver, set I47=0 as target, changing cell M7, and get it updated to 1,9960%.
 
You must log in or register to reply here.
Back
Top