How to Find Roots in Excel
Calculate a square root.
It can be any positive number or a cell reference to the location of the data in a worksheet.
To calculate a root, simply supply an inverse exponent for example, a square root is 1/2.
Pexels / Pixabay
The POWER() function is useful for both powers and exponents.
For example:
yields 16, whereas:
also yields 16, which is the square root of 256.
Roots are the inverse of powers.
Calculate the roots of imaginary numbers.
Excel offers the IMSQRT() and IMPOWER() functions to return roots and powers of imaginary numbers.
The syntax of these functions is identical to the real-number versions.
