Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
solver for if statment and discret function?
Hi,
I am doing stock pattern analysis and try to find the criterias I should set to lead to the maximum return over years. For example, I have decision cell A ( if Stock price X%, the sell). The B cell is the return over 3 years. When I run the solver, it either didn't change the original value or give me the parameters not reaching the maximun returns. Is it because the function is not continuous or solver doesn't deal with "if" statement that well? Can anybody suggest some other ways to solve this problems? Is there any other function in Excel or VBA I should use in the optimization exercise? Thanks a lot! Chia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
max function with conditional statment | Excel Worksheet Functions | |||
Function =IF statment limits | Excel Discussion (Misc queries) | |||
Solver function | Excel Programming | |||
Solver: 2nd function of SolverSolve | Excel Programming | |||
IF statment/function | Excel Discussion (Misc queries) |