Manuals/calci/BOTTOMN
BOTTOMN(Array, n)
- is the set of elements in an array
- is the number of bottom elements of a given array to be displayed
Description
- BOTTOMN() function is used to display the mentioned number of bottom values in an array.
- Argument can be text, numbers, or any special characters like @,&...
- should be entered in double quotes("") for text and special characters.
- Argument should be a positive integer, less than or equal to the number of values in array. with decimal value displays an error message
Examples
- BOTTOMN([1,9,15,34,22,6],2) = 22 6
- BOTTOMN(1..10,5) = 6 7 8 9 10
- BOTTOMN([200,300,400],0.6) = null
- BOTTOMN(["name","address","pin"],1/3) = null
- BOTTOMN(1..5,-2) = Error
- BOTTOMN(1..5,7) = Error
Related Videos
See Also
References