Automatically increase value

**Jazzy Max** · 12-14-2009, 06:03 PM

Hi All,

I have attached a spreadsheet, in which I have highlighted the following cells (I2, J2, G31 and I31)

Now here is where I need assistance, I would like:

Please Login or Register  to view this content.

I31 is fixed and wont be changed.

What the highlighted cells are actually trying to tell us is that if someone is 65 they would need an income of $169,367p.a and the minimum target is $190,500p.a

So in order for G31 to equal I31, I2 should equal 76.3344. This is the critical bit...is this possible..

I have tried to explain this as well as I could, apologies for it sounding confusing. If you need any further clarification, please let me know (I'm sure you will anyway) :D

Thank you very much

**seckert** · 12-14-2009, 06:54 PM

If I understand your question, you want to find the minimum retirement age by varying the value in cell I2 until G31 = I31. You can do this easily using Goal Seek. (Data.What-if Analysis.Goal Seek) However, by my calcs, I2 should equal 67.1379.

**Jazzy Max** · 12-14-2009, 07:07 PM

I have tried to do it using Goal seek. Yes it does work.

However, I would prefer this to be done automatically..i.e. the spreadsheet opens up and the figure is updated.

Is there a way, where we can loop I2 all the way up to the 67.1379 and stops automatically once G31 reaches amount in I31??

If that can be, it would be great help

**Jazzy Max** · 12-14-2009, 11:07 PM

Also, Goal Seek wouldn't work that well as Cell I2 would contain a formula that calculates the Retirement age.

So I would like the "automatically obtained figure" to show up in a different cell.

**seckert** · 12-15-2009, 03:07 PM

Try this - I've found this method to be pretty good for creating your own solver.

Please Login or Register  to view this content.

You'll may want to add code to move the answer to a different cell, and replace the original formula in I2, but that's up to you.

Hope this helps

SAE

**Jazzy Max** · 12-15-2009, 06:36 PM

Wow that's great!! Thank you so much for your help :D it worked beautifully.

P.S - if I want the return value to be displayed in cell K2...what would I need to enter in the macro?

Thank you once again...

**seckert** · 12-16-2009, 12:26 PM

after the Wend statement:

Please Login or Register  to view this content.

To reset the formula in cell I2:

Please Login or Register  to view this content.

SAE

**Jazzy Max** · 12-21-2009, 06:13 PM

Excellent thank you, reps added

Automatically increase value

LinkBack

Thread Tools

Rate This Thread

Display

Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Re: Automatically increase value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions