Manuals/calci/BOTTOMN

Revision as of 04:22, 14 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''BOTTOMN(Array, n)'''</div><br/> *<math>Array</math> is the set of elements in an array *<math>n</math> is the number of bottom elements of a giv...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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