Manuals/calci/MIDDLE

MIDDLE(Array, Count)

• $Array$ is the set of elements in an array
• $Count$ is the number of middle elements of a given array to be displayed

Description

• MIDDLE() function is used to display the mentioned number of middle values in an array.
• Argument $Array$ can be text, numbers, or any special characters like @,&...
• $Array$ should be entered in double quotes("") for text and special characters.
• Argument $Count$ should be a positive number less than or equal to the number of values in array. Count with decimal value is rounded to nearest integer.
• For $Count$ greater than number of elements in array, Calci displays null values.

Examples

• MIDDLE([1,9,15,34,22,6],2) = 15 34
• MIDDLE(1..10,5) = 3 4 5 6 7
• MIDDLE([200,300,400],0.6) = 300
• MIDDLE(["name","address","pin"],1/3) = address
• MIDDLE(1..5,-2) = Error
• MIDDLE(1..5,7) = null null null null null null null

Related Videos

Determining Top and Bottom Values

See Also

• BOTTOM

• TOP

• MIDN

References

• Array

• List of Main Z Functions

• Z3 home