SMALL()

Syntax. SMALL(array,k)

Definition. This function returns the smallest k-value in a data set. Use this function to return values with a certain relative size in a data set.

Arguments

  • array (required). The array or range of data for which you want to determine the smallest k-value

  • k (required). The position of the element in the array or cell range to return

Background. The SMALL() function is the counterpart to the LARGE() function and returns the smallest value in a table. Note the following about the SMALL() function:

  • If array is empty, SMALL() returns the #NUM! error value.

  • If k is less than or equal to 0 or greater than the number of data points, the function returns the #NUM! error.

  • If n is the number of data points in a range, then SMALL( ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial