XROOT

Name

Root Y of value X

Description

Returns the root, Y, of a specified number, X .

Syntax

XROOT(value1, value2)

Remarks

Specify the number for which you want the root using the value1 argument. Specify the root you want using the value2 argument. If value2 is an even number, value1 must be a positive number.

See also POWER and SQRT.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

XROOT(R1C2,3)
XROOT(A3,4)
XROOT(C4,B2)
XROOT(256,3)=6.3496042079