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

Determining Top and Bottom Values


See Also


References