ROOTN (n-th root)

<< Click to Display Table of Contents >>

ROOTN (n-th root)

Syntax:

ROOTN(Number [, n])

Description:

Returns the n-th root of a number. If n is omitted, the square root is returned (n=2).

n should be an integer. Digits to the right of the decimal point are ignored.

If n is even, Number must be ≥ 0.

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Tip: Alternatively, the n-th root of a number can be calculated using the following Excel compatible function:

ROOTN(Number, n) equals POWER(Number, 1/n)

Example:

ROOTN(25) returns 5

ROOTN(-25) returns a #NUM! error value

ROOTN(125, 3) returns 5

ROOTN(-125, 3) returns -5

See also:

SQRT, POWER