Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!! |
#2
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Solver | Excel Worksheet Functions | |||
Question about Excel 2003 | Excel Discussion (Misc queries) | |||
Historical Excel question statistical capabilities | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |