formula to provide greatest numerical value from multiple columns

[#1]

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

[#2]

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

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

[#3 · Accepted solution]

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.

 

[#4]

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!