goal seek and negative values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im using goal seek and from time to time it returns a negative value. how do i prevent this? i have set validation rules for the cells so that i cannot manually enter a negative value but goal seek seems to igore this.
 
Steve,

Use Solver instead. Put in a constraint: A2>=0.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

steve said:
im using goal seek and from time to time it returns a negative value. how
Click to expand...
do i prevent this? i have set validation rules for the cells so that i
cannot manually enter a negative value but goal seek seems to igore this.
 
I have a similar problem, which remain unanswered for some time.
Can any one suugest a solution for this by placing some constraint fo
the "changing cell" in the following goal seek code

Sub GoalSeek()
Range("TARGET").GoalSeek Goal:=0, _
ChangingCell:=Range("RATE")
End Sub

Help appreciated.

m
 
Back
Top