For non-linear non-convex problems, Solver, like most other
optimization packages, cannot guarantee a global optimum. It might
work depending on the options selected as well as the starting values
for a specific solution attempt.


Tushar,

As a side note, the nonlinear nonconvex problems can now reach a proved
global optimum, thans to the new technology progress. Of particular
approach is the one based on convexification and branch-and-bound
methods. This guaranteed approach is also availabe in an Excel addin
solver, namely What's Best. If you are interested, you might want to
check out the product website at www.lindo.com. As I know, there is a
free version with limited capacity.

Regards,
Tony