topic formula to provide greatest numerical value from multiple columns in Discussions

formula to provide greatest numerical value from multiple columns

aadecarlojr — Sat, 10 Jun 2023 23:53:08 GMT

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

Re: formula to provide greatest numerical value from multiple columns

txnelson — Sat, 13 Aug 2022 00:08:42 GMT

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

Jeff_Perkinson — Mon, 15 Aug 2022 19:27:26 GMT

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

aadecarlojr — Tue, 16 Aug 2022 15:33:46 GMT

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!