The IntervalMatch prefix is used to create a table matching discrete numeric values to one or more numeric intervals.
lets assume there is table
Student:
StName
| Marks
|
|---|
| AB | 25 |
| BA | 40 |
| CA | 55 |
| DA | 60 |
| EA | 75 |
and we have a table for grades
Status:
Min
| Max | Grade |
|---|
| 0 | 29 | Fail |
| 30 | 45 | Third |
| 46 | 59 | Second |
| 60 | 74 | First |
| 75 | 100 | Honors |
now we can find Student grades by using IntervalMatch() by following script
intervalmatch(Marks) load Min,Max resident Status;
now Student's Grade is obtained by matching the Marks in the interval of minimum and Maximum value.
so when we create a table box for the grade of the student following table is obtained.
StName
| Grades
|
|---|
| AB | Fail |
| BA | Third |
| CA | Second |
| DA | First |
| EA | Honors |
because 25 comes between the interval of 0-29 for that grades is fail.This is logic on which intervalmatch() works.
