Microsoft Office Tutorials and References

In Depth Information

COUNTBLANK

Counts the number of blank cells in the argument range.

Counts the number of cells that meet the criteria you specify in the

argument.

COUNTIF

COUNTIFS*

Counts the number of cells that meet multiple criteria.

Returns covariance, the average of the products of paired devi-

ations.

COVARIANCE.P**

Returns the sample covariance, the average of the products' devi-

ations for each data point pair in two data sets.

COVARIANCE.S**

DEVSQ

Returns the sum of squares of deviations.

EXPON.DIST**

Returns the exponential distribution.

F.DIST**

Returns the F probability distribution.

F.DIST.RT**

Returns the F probability distribution.

F.INV**

Returns the inverse of the F probability distribution.

F.INV.RT**

Returns the inverse of the F probability distribution.

F.TEST**

Returns the result of an F-test.

FISHER

Returns the Fisher transformation.

FISHERINV

Returns the inverse of the Fisher transformation.

FORECAST

Returns a value along a linear trend.

FREQUENCY

Returns a frequency distribution as a vertical array.

GAMMA***

Returns the gamma function value.

GAMMA.DIST**

Returns the gamma distribution.

GAMMA.INV**

Returns the inverse of the gamma cumulative distribution.

GAMMALN

Returns the natural logarithm of the gamma function, G(x).

GAMMALN.PRECISE** Returns the natural logarithm of the gamma function, G(x).

GAUSS***

Returns 0.5 less than the standard normal cumulative distribution.