You can use the following formula to calculate the square root of a value in Google Sheets:
=SQRT(A1)
And you can use the following formula to calculate the cube root of a value in Google Sheets:
=A1^(1/3)
The following examples show how to use each formula in practice.
Example 1: Calculate Square Root in Google Sheets
The following screenshot shows how to calculate the square root of values in Google Sheets:
Note that we typed the following formula into cell B2:
=SQRT(A2)
We then copy and paste this formula down to every cell in column B.
Example 2: Calculate Cube Root in Google Sheets
The following screenshot shows how to calculate the cube root of values in Google Sheets:
Note that we typed the following formula into cell B2:
=A2^(1/3)
We then copy and paste this formula down to every cell in column B.
Example 3: Calculate Nth Root in Google Sheets
We can use the following generic formula to calculate the nth root of a value in Google Sheets:
=A2^(1/n)
For example, we could use the following formula to calculate the fourth root of a value:
=A2^(1/4)
The following screenshot shows how to calculate the fourth root of values in Google Sheets:
Note that we typed the following formula into cell B2:
=A2^(1/4)
We then copy and paste this formula down to every cell in column B.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
How to Calculate Descriptive Statistics in Google Sheets
How to Calculate a Five Number Summary in Google Sheets
How to Find Outliers in Google Sheets