BookmarkSubscribe
Choose Language Hide Translation Bar
bnossaman
Community Trekker

IfMin and OR for more than 2 columns ...

Someone know of a script to allow a minimum value meeting less than a predetermined cutoff value for more than 2 columns?

0 Kudos
2 REPLIES 2
msharp
Super User

Re: IfMin and OR for more than 2 columns ...

Something like:

cutoff = 2; columnList = {:Column 1, :Column 2, :Column 3}; If(Minimum(columnList) < cutoff, Minimum(columnList), cutoff)

Where cutoff is the cutoff value the minimum has to be less than and columnList is a list of columns.  Here Column 4 will be the minimum value of column 1, 2 or 3.  If none of them are less than the cutoff, then column 4 will be equal to the cutoff for that row.

If this doesn't work you will need to expand upon what you are looking for.  Your question is pretty vague.

bnossaman
Community Trekker

Re: IfMin and OR for more than 2 columns ...

Thank you MSharp for your prompt and effective reply. You have taught me a new method, much appreciated.

0 Kudos