Archive

NORM.INV

The inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORM.DIST

Returns the normal distribution for the specified mean and standard deviation.

MINX

Returns the smallest value that results from evaluating an expression for each row of a table.

MINA

Returns the smallest value in a column.

MIN

Returns the smallest value in a column, or between two scalar expressions.

MEDIANX

Returns the median number of an expression evaluated for each row in a table.

MEDIAN

Returns the median of numbers in a column.

MAXX

Evaluates an expression for each row of a table and returns the largest value.

MAXA

Returns the largest value in a column.

MAX

Returns the largest value in a column, or between two scalar expressions.