SMALL

Purpose

  • Returns the k-smallest value in a range of numbers, where k is user-defined

Example

SMALL

  • Here is a screenshot, for reference:

SMALL

  • Notice that:
    • 100 is the smallest number, so 100 is returned when k is equal to 1
    • Non-numerical values are ignored
    • When we defined k as 5, 0, and -1, an error occurs. Why? There are no fifth, zero, and negative one smallest numbers

Syntax

  • =SMALL(array, k)

Arguments

  • array
    • This is the cell range in question (and you are looking for the k-smallest number in this range)
  • k
    • A value of:
      • 1 will return the smallest number in the array
      • 2 will return the 2nd smallest number in the array
      • Etc.
    • This can be a hard-coded number, cell reference, or calculation

External Links