Thread: Solver problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
prabhat prabhat is offline
external usenet poster
 
Posts: 3
Default Solver problem

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