The PERCENTILE.EXC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
1904, 2019
Category Archives: Functions
1904, 2019
The PERCENTILE.INC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
1904, 2019
The PERCENTILE function
It returns the k-th percentile of values in a range. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are PERCENTILE.INC and PERCENTILE.EXC.
1904, 2019
The QUARTILE.EXC function
It returns the quartile of a data set based on percentile values from 0..1, exclusive.
1904, 2019
The QUARTILE.INC function
It returns the quartile of a data set based on percentile values from 0..1, inclusive.
1904, 2019
The QUARTILE function
It returns the quartile of a data set. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are QUARTILE.INC and QUARTILE.EXC.
1804, 2019
The LOOKUP Function
Use LOOKUP when you need to find something in a single row or column and find a value from the same position in a second row or column.
1804, 2019
The HLOOKUP Function
Use HLOOKUP when you need to find things in a table or a range by column. It is part of the lookup and reference functions of Excel .
1804, 2019
The VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. It is part of the lookup and reference functions of Excel.
1804, 2019
The OFFSET Function
The OFFSET function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells .
