Prabhat -

If you want the efficient frontier, maybe you could use the VBA solution at
http://www.solver.com/invefficientfrontier.htm
or perhaps you could adapt it for your specific model and situation.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"prabhat" wrote in message
...
I want to maximize one value (expected rate of return) and minimize another
value (variance) at the same time. Is there a way to find an optimum value
rather than just finding either the maximum value of expected return, or
finding the minimum value of variance.

Is it possible to generate a table for a range of values ? Is it possible
to
generate a graph of expected return vs variance.

Thanks,
Prabhat