Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Greater than or equal to in pick match

I've got an if statement like this...

    if(fabs(duration) >= 10, 10,

         if(fabs(duration) >= 9, 9,

              if(fabs(duration) >= 8, 8,

                   ...

                   )))

Can I turn it into a `pick(match())` statement?  How?

    

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe

=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)

View solution in original post

1 Reply
maxgro
MVP
MVP

maybe

=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)