# Manuals/calci/RANKS

**RANKS(r,n,o)**

- is the set of numbers.
- is the number to get ranked.
- is the number to start.

## Description

- This function gives the ranks of a each number in given set of numbers.
- It is based on the value of a number, relative to the other numbers in the list.
- In RANK(r,n,o), is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order.
- is the number to be get ranked.
- If o is zero, then the list of the numbers getting in descending order.
- If o is 1, then the list of the numbers getting in ascending order.
- When we are not mentioning the o value, then it will give the set of numbers in descending order.
- RANKS 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

1.RANKS([32,67,12,10,23],3,0)

10 | 1 | 0 |

12 | 1 | 1 |

23 | 1 | 2 |

32 | 1 | 3 |

67 | 1 | 4 |

2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5)

10.002 | 1 | 5 |

32 | 1 | 6 |

32.2 | 1 | 7 |

45 | 1 | 8 |

54.01 | 2 | 9.5 |

76 | 1 | 11 |

100 | 1 | 12 |

210.3 | 1 | 13 |

## Related Videos

## See Also

## References