goal seek

I have a client with an extremely large workbook and when they run a goal seek it can sometimes up to two minutes to perform the operation. I have tried running a goal seek via VBA and setting Calculations to manual before running the operation but this doesn't seem to help. Does anyone have any...

Hi, I have a calculator that derives a monthly payment by accounting for net capital amount (combination of total capital amount, deposit and part exchange), flat interest rate and loan period. I need to make it all singing and dancing, in particular by inserting buttons next to price...

When using goal seek, a cell becomes locked. The cell has no precedent cells but does have dependent cells. Has anyone experienced this issue and is there a fix? i.e. I use goal seek to find a value and then can not hard enter the initial value into the cell.

Hello, I have limited/no VBA experience but significant excel experience (using 2007 now). I'm trying to create an automated Goal Seek function that will automatically (upon changing of "to value", which I also need the function to seek a particular cell and not a set value) run a Goal Seek and...

One of the features I loved in 2003 version was the ability to drag/drop a point on a graph and being able to recalc that value with goal seek. That functionality seems to have been lost in 2007 version. Does anyone know of a way to drag/drop in a graph and use goal seek to change the...

Hi there! I'm trying to do a goal seek with an offset but i haven't written code (and even when I did only took an intro class) in 5 years! Sos I am trying to change the value in SHEET1 cell E49 equal to the VALUE in cell E436 on the same sheet ("SHEET1") by changing cell E38 on tab SHEET 2...

Hi, I am trying to use Goal Seek or Solver to solve a margin equation but since this is variable due to different prices I wanted to find out how I can make Goal Seek or Solver do it automatically? Is there a way to use an If statement to do this? Thank you in advance for your help.

In a spreadsheet I'm using, one of the value's for a cell, should always be manipulated using a goal-seek to another cell. i.e. Cell A1 is value of B1/B2 B2 is = to C1/C2 In order to figure out A1, I do a goal seek, Set Cell A1 to Value 6, By changing cell C2. Is there a way that I can set a...

Hello All, I am having a bit of a problem with the syntax of a Goal Seek Command in a macro and would certainly appreciate any assistance. I have 30 cells which may trigger a goal seek if a certain value is above 0. The cells I am checking for the value > 0 are in D138 thru AE138. The goal...

Hello Forum members, I am new to his forum. I have built a financial model detailing the costs for a certain project and the way in which the costs are financed. At a certain point I am running a macro that has the objective to minimize the costs that are not yet financed by taking out debt...

Looking for a suggestion for a formula to solve for a final cash flow given an XIRR target? For example: Formula in cell I3=XIRR($A2:I2,$A$1:I$1,0.1) I've goal seeked for value in cell I2 that yeilds 20%, 30% and 40% IRR's. Looking for formula to do the same. <TABLE style="WIDTH: 388pt...

I apologize if this is a little off topic: Is the "Goal Seek" function available for the mobile version of Excel? If it is, do I need to download something to install on my phone? Thanks in advance for your help! Josh

Hie all I would like to use combination of goal seek and conditional formatting simultaneously!!! Is it possible? i.e. If I restrict values in a cell and then allow goal seek to find desired solution as desired. Or other way round. Thanks in Advance Adeel

i am looking for a UD function that mimics the goal seek command automatically. I have a need to goal seek (or solve) multiple values iwthin a single spreadsheet upon a recalculation. Is there such thing available. I did see a few notations regarding a goal seek function (partial code I think...