Usage
x to y
Creates the range x to y.
Examples
100.00 to 250.00
The range of consecutive numeric values
beginning with 100.00 and ending with 250.00, including the end values.
CDate(1990, 09, 01) to CDate(1990, 09, 20)
The range of consecutive dates beginning
with September 1, 1990, and ending with September 20, 1990. Both September 1
and September 20 are included in the range.
"Aaron" to "Lusk"
The range of consecutive text values
beginning with
“Aaron” and ending with
“Lusk”, including the beginning and end values.
Comments
You cannot create a formula that has
a range as a result. Thus,
Make Range is always used in conjunction with
other operators such as the
In Range operator. The combination of
Make Range and
In Range produces a formula that gives a
single TRUE or FALSE value, not a range.
The program comes with a number of
Date Ranges, such as
YearToDate, that are preset for your
convenience.