pietermeulendijk
New Member
- Joined
- Jan 15, 2010
- Messages
- 2
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 for these costs.
The costs that are not yet financed consist of two parts, so the goal seek function needs to minimize both parts. Let's call the two cells with the costs that are not yet financed A1 and A2.
Currently, I use this function:
wf.Range("Fin_shortage").GoalSeek Goal:=0, ChangingCell:=wm.Range("srDebt")
The cell called "Fin_shortage" is the problem: if I set it to be "A1+A2" the minimization does not work. Also if I set it to be "A1-A2" it does not work. Also "A1*A2" gives no correct result, as that minimizes the product of the cells, but not the individual cells, which is what I am looking for. I want both cells A1 and A2 to be minimized by changing cell "srDebt".
Who can help me achieving my goal? All help appreciated!
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 for these costs.
The costs that are not yet financed consist of two parts, so the goal seek function needs to minimize both parts. Let's call the two cells with the costs that are not yet financed A1 and A2.
Currently, I use this function:
wf.Range("Fin_shortage").GoalSeek Goal:=0, ChangingCell:=wm.Range("srDebt")
The cell called "Fin_shortage" is the problem: if I set it to be "A1+A2" the minimization does not work. Also if I set it to be "A1-A2" it does not work. Also "A1*A2" gives no correct result, as that minimizes the product of the cells, but not the individual cells, which is what I am looking for. I want both cells A1 and A2 to be minimized by changing cell "srDebt".
Who can help me achieving my goal? All help appreciated!