Manuals/calci/RANK

From ZCubes Wiki
Jump to navigation Jump to search
RANK(n,r,o)


  • is the number to be ranked.
  • is the range of numbers .
  • indicates the number is ranked in ascending or descending order.

Description

  • This function gives the rank of a given set of numbers.
  • It is based on the value of a number, relative to the other numbers in the list.
  • In , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the number to be get ranked, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} is the range of the cells to find the ranking the number and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} indicates the number is ranked in ascending or descending order.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is zero, then the list of the numbers getting in descending order.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is 1, then the list of the numbers getting in ascending order.
  • When we are not mentioning the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} value, then it will give the set of numbers in descending order.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle RANK} gives the spare numbers that having the same rank.
  • The occurrence of the spare number affects the ranks of the next numbers.
  • This function will return the result as error when any one of the argument is non-numeric.

Examples

Spreadsheet
A B C D E F G H
1 20 7 5 17 32
2 10 4 -1 0 15 24 45
3 4 -1 -47 -23 0 -18 1 -35
  1. =RANK(7,A1:E1,0) = 4
  2. =RANK(7,A1:E1,1) = 2
  3. =RANK(4,A2:G2,0) = 5
  4. =RANK(4,A2:G2,1) = 3
  5. =RANK(-1,A2:G2,0) = 7
  6. =RANK(0,A3:H3,0) = 3
  7. =RANK(0,A3:H3,1) = 6
  8. =RANK(-18,A3:H3,1) = 4

Related Videos

RANK

See Also

References