Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)