|
<< Click to Display Table of Contents >> ROOTN (n-th root) |
Syntax:
ROOTN(Number [, n])
Description:
This returns the n-th root of a number. If n is omitted, the function returns the square root (n=2).
n should be an integer. If this is not the case, PlanMaker automatically truncates the decimal places.
If n is even, Number must be ≥ 0.
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
Tip: Alternatively, you can calculate the n-th root of a number using the following Excel-compatible function:
ROOTN(Number, n) equals POWER(Number, 1/n)
Example:
ROOTN(25) returns 5
ROOTN(-25) returns the #NUM! error value
ROOTN(125, 3) returns 5
ROOTN(-125, 3) returns -5
See also: