Take the square root, or any root, of a number.
Copy this formula
=SQRT(A2)SQRT returns the square root. For any other root, raise to a fractional power: A2^(1/3) is the cube root. The caret (^) operator handles powers and roots alike.
=A2^(1/3)→4Cube root of 64 is 4.
Raise to a power
=A2^2Squares the value; POWER(A2,2) is equivalent.
You can't take the square root of a negative number. Wrap with ABS if the sign doesn't matter: =SQRT(ABS(A2)).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.