MIDRANGE
The MIDRANGE function returns the midrange value between the passed arguments.
Syntax 1
function midrange (arg-1[, arg2 ...,arg-n]) |
Syntax 2
$midrange (arg-1[, arg2 ...,arg-n]) |
Arguments
• arg-1 can be either a numeric or a alphanumeric data item or literal. Other arguments, if any, must be of the same type.
• A table can be referenced by specifying the data-name and any qualifiers that identify the table, followed immediately by subscripting where one or more of the subscripts is the word ALL. When ALL is specified as a subscript, the effect is as if each table element associated with that subscript position were specified. The order of the implicit specification of each occurrence is from left to right, with the first (or leftmost) specification being the identifier with each subscript specified by the word ALL replaced by one, the next specification being the same identifier with the rightmost subscript specified by the word ALL incremented by one. For example, "function midrange (tbl-item(all))" is equivalent to "function midrange (tbl-item(1), tbl-item(2),...,tbl-item(n))".
Result
The function returns returns the midrange value between the passed arguments.
Examples
Example - Display the midrange value between 1, 2 and 3.
display function midrange(1, 2, 3) |