cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Need to select the maximum of two column matrices and return as a column matrix.

SOLVED
Highlighted
Garnet

Need to select the maximum of two column matrices and return as a column matrix.

Hello,

I run into the situation frequently where I need to select the lesser of greater of two equations.  Suppose I have equation A and equation B.  I've input say 6 values for A and B in a single column matrix and evaluated each.  I would like to define variable C as the maximum of A or B output for each row.  I attached a worksheet that demonstrates my problem.

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Need to select the maximum of two column matrices and return as a column matrix.

Generally you would use the vectorize operator (see operators item in the tab, then under Vector and Matrix) for this job, but unfortunately, because max() and min() functions accept more than 2 arguments vectorization does not work for them.

So you have to write a small program:

Success!
Luc

3 REPLIES 3

Re: Need to select the maximum of two column matrices and return as a column matrix.

Generally you would use the vectorize operator (see operators item in the tab, then under Vector and Matrix) for this job, but unfortunately, because max() and min() functions accept more than 2 arguments vectorization does not work for them.

So you have to write a small program:

Success!
Luc

Re: Need to select the maximum of two column matrices and return as a column matrix.

Thnaks Luc.  That looks like that will accomplish my goal.  I'm not familiar with Mathcad programming so I'll have to study up on that.  At first pass I can't get the program lined up as yours is so it isn't evaluating.

Also, after m original post I found a related thread which someone helped solve using the vectorize operator and I have made that one work. 

Comparing data from two arrays

Is there a benefit of one method over the other?

Thanks again for the help.

Re: Need to select the maximum of two column matrices and return as a column matrix.

Ah, yeah, completely forgot about this trick. Essentially what Werner shows is how to obtain a max function limited to 2 arguments, such that vectorization can work.

Yes Brandon, there is an advantage: Vectorization is usually faster.

Success!
Luc