Manuals/calci/MIDN

MIDN(Array, n, fromX)

• $Array$ is the set of elements in an array
• $n$ is the number of middle elements of a given array to be displayed
• $fromX$ is the number of elements to be skipped after the first element

Description

• MIDN() function is used to display the mentioned number of values in an array, skipping the specified number of elements from the first element.
• First element of an array is displayed. Remaining $n-1$ values are displayed after skipping the $fromX$ elements from the 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 $n$ 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 $n$ greater than number of elements in array, or negative value, Calci displays first element of array.

Examples

• MIDN([1,9,15,34,22,6,7,43,21,99],4,2) = 1 34 22 6
• MIDN(1..20,5,4) = 1 6 7 8 9
• MIDN([200,300,400,500,600,700],1.6,1) = 200 400
• MIDN(["name","address","pin"],1/3) = name
• MIDN(1..5,-2) = 1
• MIDN(1..5,7) = 1

Related Videos

Determining Top and Bottom Values

See Also

• BOTTOM

• TOP

• MIDDLE

References

• Array

• List of Main Z Functions

• Z3 home