goal seek and negative values

S

steve

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.
 
E

Earl Kiosterud

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.
 
M

mpreddy

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
 
Top