533362_en-US

liliconcom

formula to provide greatest numerical value from multiple columns

I have two related columns with numerical values and I cannot figure out how to create a formula column that delivers the maximal value of the two input columns. Everything I try ends up with an "else" in the formula and I don't think I want that.

 

thanks if you know how.

 

Dr. DeCarlo

Data TableScriptingRe: formula to provide greatest numerical value from multiple columns

max( col max(:col1), col max(:col) );

I think this will give you the maximum value for the 2 columns

Re: formula to provide greatest numerical value from multiple columns

It's not clear exactly what you want, @aadecarlojr.

 

If you want the maximum value across all the values of the two given columns then the JSL that @txnelson gave above will work.

 

If, on the other hand, you want something like this:

 

A	B	Max of A and B
1	2	2
4	3	4
8	7	8

Then the formula:

 

Maximum(:A, :B)

will give you that.

 

Re: formula to provide greatest numerical value from multiple columns

Thanks to Jeff and TxNelson. I did want the latter, row by row maximum of two columns and that works.  In my research we entered separate R and L data but also want a column variable that contains the max from either R or L.

 

Love solutions!