Difference between revisions of "NthMaxList"
Jump to navigation
Jump to search
(→Usage) |
m (Reverted edits by 176.8.90.7 (talk) to last revision by JoshM) |
||
| 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> | ||
| + | Where: | ||
| + | |||
| + | :'''N''' - a numerical expression, indicating the rank of the value to be returned. | ||
| + | |||
| + | :'''Value1''', '''Value2''', '''Value3''', etc. - numerical expressions. | ||
| + | |||
== Example == | == Example == | ||
<syntaxhighlight>NthMaxList(4, -15, -5, 0, 6, 12);</syntaxhighlight> | <syntaxhighlight>NthMaxList(4, -15, -5, 0, 6, 12);</syntaxhighlight> | ||
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.
