Subscribe Bookmark RSS Feed

IfMin and OR for more than 2 columns ...

bnossaman

Community Trekker

Joined:

May 18, 2016

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

2 REPLIES
msharp

Super User

Joined:

Jul 28, 2015

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

Joined:

May 18, 2016

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