value by ranges

A Score Level 1

I need an expression which finds corresponding value based on ranges:

Input:
x
{v1,v2,...,vn+1}
{r1,r2,...,rn}

Result:
if (x<=r1) then v1
else if (x<=r2) then v2
....
else if (x<=rn) then vn
else vn+1

Thanks

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data