Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Solver and Negative Numbers

Status
Not open for further replies.

davidmo

Technical User
Apr 8, 2003
97
US
Can Excel Solver calculate negative numbers in its solution? I saw on the options area the "Assume Non-Negative" button but this doesn't help me.

Thanks.
 
The non-negative option is useful when you are solving problems where it is phyically impossible to have negative quantities. For example: you can have 0, 1, 2, etc. wives (at various times), but it is impossible to have -1 wife.

Solver can definitely find negative solutions to problems.

If you want to learn more about Solver, its developer Frontline Systems maintains a good web site at Check out the tutorial section in particular.
Brad
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top