While entering the inputs for its dialogue, the second parameter ""To Value"
has to be entered manually as a value. Instead of entering value here, we can
not reference this field to any cell in worksheet (As the application does
not allow you for this).
Is there any alternative solution to declare some deafult cell locations as
inputs to all 3 fields of the Goal Seek dialogue thus automating the inputs
and getting the result staright away.
"MUEEN SEHDI" <MUEEN...@discussions.microsoft.com> wrote in message
news:AB6FF6B3-CD7E-4EB7...@microsoft.com...
I have tried to explore "Solver" but the limitation is the same that I have
to enter the target values in Solver Dialoue and I can not refer that field
to a particluar cell".
I hope above is a clear picture of the problem I am facing. I am very much
hopeful that you may help me sort this out.
Regards,
Mueen Sehdi
"Bernard Liengme" wrote:
> .
>
Here is a simple scenario to show you how to do what you want: refer to a
cell in a Value problem
In A1 enter some number like 3
In A2 enter the formula =A1^2-10 (with A1=3, the result is -1)
Suppose I want Solver to alter A1 such that A2 has a result of 100
In A3 enter 100 (my target value)
Open Solver dialog; clear the box labeled Set Target Cell (select what is in
it and hit Delete key)
In the By Changing box enter A1
The add this constraint A2=A3
Hit the Solve button
Solver finds that with A1=10.488....., A1^2-10 has value of 100
This is the correct way to use Solver. The Set Target Cell should be used
only for Min/Max problems and never for Value problems
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"MUEEN SEHDI" <MUEEN...@discussions.microsoft.com> wrote in message
news:FF8CE09B-2CA8-4DA0...@microsoft.com...
Just an idea. You can't reference a cell by itself, but in VBA, you can
set it to the "Value" of that cell. Perhaps...
Sub Demo()
[A1] = 3
[A2].Formula = "=A1^2-10"
[A3] = 100
[A2].GoalSeek [A3].Value, [A1]
End Sub
= = = = = = = =
Dana DeLouis