Range

[pkpandey]

How to get the minimum and maximum range of a value falling between e.g.

Say User input Value is 75 and  we have a range like

0 to 50

52 to 70

71 to 80

81 to 100

I have to get the the range 71 and 80 because 75 falls between this range.

[Anonymous]

Try to use the Inline table and fetch the result

[tresesco]

Look at class(). If the intervals are not equi-distant, you might have to use nested ifs.

[MK_QSL]

Consider that you have variable named VALUE

User can change the VALUE of this variable....

Use below expression Text Box or in Chart ....

=IF(VALUE >0 and VALUE <= 50, '0 to 50',

  IF(VALUE > 50 and VALUE <=70, '51 to 70',

  IF(VALUE > 70 and VALUE <= 80, '71 to 80',

  IF(VALUE > 81, '81 to 100'))))