Manuals/calci/MIDDLE
Jump to navigation
Jump to search
MIDDLE(Array, Count)
- is the set of elements in an array
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} can be text, numbers, or any special characters like @,&...
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} should be entered in double quotes("") for text and special characters.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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
See Also
References