Difference between revisions of "Manuals/calci/TOPN"
Jump to navigation
Jump to search
(Created page with "topn") |
|||
| Line 1: | Line 1: | ||
| − | + | <div style="font-size:30px">'''TOPN (Array,n)'''</div><br/> | |
| + | *<math>Array</math> is the set of numbers. | ||
| + | *<math>n</math> is the number. | ||
| + | |||
| + | ==Description== | ||
| + | *This function shows the starting 'n' values of the given array. | ||
| + | *In <math>TOPN(Array,n)</math>,<math>Array</math> is the set of values and <math>n</math> is the number of the value. | ||
| + | *<math>TOPN</math> shows the first 'n' values from the given set of values. | ||
| + | |||
| + | ==Examples== | ||
| + | #TOPN([20,13,17,19,22,26,32,56,45,10,98,112,134,201],6) = 20 13 17 19 22 26 | ||
| + | #TOPN([1.2,8.001,2.8,10,4.001,6,2],0) = 1.2 | ||
| + | #TOPN([100,12,31,89,12,17,19],10)= 100 12 31 89 12 17 19 | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/LOWER | LOWER ]] | ||
| + | *[[Manuals/calci/UPPER | UPPER]] | ||
| + | *[[Manuals/calci/SMALLLETTERS | SMALLLETTERS ]] | ||
| + | |||
| + | ==References== | ||
| + | [http://www.thetoptens.com/top-ten-greatest-numbers/ Top] | ||
Revision as of 16:15, 6 December 2016
TOPN (Array,n)
- is the set of numbers.
- is the number.
is the set of numbers.
is the number.Description
- This function shows the starting 'n' values of the given array.
- In , is the set of values and is the number of the value.
- shows the first 'n' values from the given set of values.
,
shows the first 'n' values from the given set of values.Examples
- TOPN([20,13,17,19,22,26,32,56,45,10,98,112,134,201],6) = 20 13 17 19 22 26
- TOPN([1.2,8.001,2.8,10,4.001,6,2],0) = 1.2
- TOPN([100,12,31,89,12,17,19],10)= 100 12 31 89 12 17 19