I need to check comparative three conditions and for each output I need to perform some action. can anybody please suggest

[Saurav Purkayastha]

I need to check three comparative conditions and for each status I need to perform some action. can anybody please suggest

Requirment:

Need to check if a numeric value is within a number range by using comparative function. Depending on status i need to ggive a constant input to numeric function.

[dlanger]

See attachment for a solution approach...

[altenbach]

Easiest is suing an array of range boundaries, e.g. as follows:

(Found here)

Now it is fully scalable and  independent of the number of ranges. The solution in the earlier post would get complicated quickly whenever the number of ranges or boundary locations changes.