Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I would like to go through the same worksheet several times, changing "index" and the various parameters, and put the calculation results in the same Rez matrix, in the corresponding "index" column. Unfortunately the previously defined columns are set to zero.
@ID_10962613 wrote:
I would like to go through the same worksheet several times, changing "index" and the various parameters, and put the calculation results in the same Rez matrix, in the corresponding "index" column. Unfortunately the previously defined columns are set to zero.
Your worksheet does not show much of what you be trying to achieve.
Not sure what the input should be and what you expect as a result.
Your function RR just returns the vector mx if the first function argument is 0, otherwise the return value is 0.
In case that the second function argument is not a vector, the function returns a 1x1 matrix containing it if opt=0.
I have no idea what you are trying to achieve, which worksheet and which calculations you would like to run several times and which 'index" (of what?) you want to change. And if you intend to use variables like "Option" and "Tab" you sure have to define them before you make use of them.
You will have to explain in more detail what you want to achieve. Provide examples and state what you expect as result.
Like Werner, I'm not sure what you're trying to achieve without some data and examples of expected output.
However, as a wild guess, is it something along these lines?
I haven't got the mighty M15, so I had to import your worksheet into Mathcad Prime 10. It shouldn't be too hard to translate back into M15 (by hand!).
Stuart