How to Calculate Square Root & Cube Root in Google Sheets


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:

square root 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:

cube root 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

Leave a Reply

Your email address will not be published.