﻿ RANK.AVG | Spread.NET 15 Formula Reference
Formula Functions / Functions R to S / RANK.AVG
In This Topic
RANK.AVG
In This Topic

#### Summary

This function returns the rank of a number in a set of numbers.

#### Syntax

RANK.AVG(number,array,order)

#### Arguments

This function has these arguments:

Argument Description
number Number whose rank you want to return
array Reference to the set of numbers
order [Optional] How the number is ranked, either in descending order (0 or omitted) or ascending order (non-zero value)

#### Remarks

The size of the returned number is relative to other values in the list. The average rank is returned if more than one value has the same rank.

#### Data Types

Accepts numeric data for the number argument, a reference for the array argument, and numeric data for the order argument. Returns numeric data.

#### Examples

RANK.AVG(B3,B1:B8,1)

RANK.AVG(R3C2,R1C2:R8C2,1)

#### Version Available

This function is available in Spread for Windows Forms 11.0 or later.