Choose Language Hide Translation Bar
Highlighted
bnossaman
Level I

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?

2 REPLIES 2
Highlighted
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.

Highlighted
bnossaman
Level I

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.

Article Labels

    There are no labels assigned to this post.