question on excel Solver
 

if i use solver find the Maximization of net profit which is from factor that
generate by RAND()
e.g the sales is randomly generated with rand(), the changing cell is the
number of produce
then the net profit is affected by the rand() and solver couldnt solve it
out ...
is there any suggestion to solve this problem ?

Or is there anyway to lock those random number [ rand() ]

Please help!!!!

Select the random number and then use Edit | Copy | Edit | Paste Special |
Values.

--

Vasant

"Avalon" wrote in message
...
if i use solver find the Maximization of net profit which is from factor
that
generate by RAND()
e.g the sales is randomly generated with rand(), the changing cell is the
number of produce
then the net profit is affected by the rand() and solver couldnt solve it
out ...
is there any suggestion to solve this problem ?

Or is there anyway to lock those random number [ rand() ]

Please help!!!!