Difference between revisions of "NthMaxList"
Jump to navigation
Jump to search
(Created page with "Returns the Nth highest value of the specified numerical expressions. ==== Usage ==== <syntaxhighlight>NthMaxList(N,Value1,Value2,Value3, etc.)</syntaxhighlight> Where: [...") |
m (Reverted edits by 176.8.90.7 (talk) to last revision by JoshM) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
Returns the Nth highest value of the specified numerical expressions. | Returns the Nth highest value of the specified numerical expressions. | ||
| − | + | == Usage == | |
| − | <syntaxhighlight>NthMaxList(N,Value1,Value2,Value3, etc.)</syntaxhighlight> | + | <syntaxhighlight>NthMaxList(N, Value1, Value2, Value3, etc.);</syntaxhighlight> |
| − | Where: | + | Where: |
| + | |||
| + | :'''N''' - a numerical expression, indicating the rank of the value to be returned. | ||
| − | + | :'''Value1''', '''Value2''', '''Value3''', etc. - numerical expressions. | |
| − | |||
| − | |||
| − | |||
| + | == Example == | ||
| + | <syntaxhighlight>NthMaxList(4, -15, -5, 0, 6, 12);</syntaxhighlight> | ||
| + | Will return a value of -5, the fourth highest value of the specified numerical expressions. | ||
| + | |||
| + | == Notes == | ||
| + | * See [[MaxList]] to return the highest value of the specified numerical expressions. | ||
| + | * See [[MaxList2]] to return the second highest value of the specified numerical expressions. | ||
[[Category:Math and Trig]] | [[Category:Math and Trig]] | ||
Latest revision as of 12:42, 13 February 2012
Returns the Nth highest value of the specified numerical expressions.
Usage
NthMaxList(N, Value1, Value2, Value3, etc.);
Where:
- N - a numerical expression, indicating the rank of the value to be returned.
- Value1, Value2, Value3, etc. - numerical expressions.
Example
NthMaxList(4, -15, -5, 0, 6, 12);
Will return a value of -5, the fourth highest value of the specified numerical expressions.
