next up previous contents index
Next: SQRT Up: A. Function Reference Previous: SLN   Contents   Index


SMALL

Syntax: SMALL(R, N)

R = range of cells containing the numerical data
N = the nth position from the smallest in the range specified

SMALL returns the Nth smallest number in range R. Cells containing blanks or text are ignored.

Examples:

A1..A9 = 1, 4, 8, 3, 7, 12, 54, 8, 23

SMALL(A1..A9, 3) = 4

SMALL(A1..A9, 1) = 1

SMALL(A1..A9, COUNT(A1..A7)) = 54

Excel function: SMALL


next up previous contents index
Next: SQRT Up: A. Function Reference Previous: SLN   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003