In this tutorial you will learn How to **Calculate Square Root and Cube Root in Google Sheets**

To calculate the Square root of a value in Google Sheet you can use the below function

### Syntax

SQRT(value)

**Value**– Here value inside the bracket will be the number for which square root needs to be calculated .**Value**should be a postive number if it is a negative value ,SQRT function will return an`#NUM!`

error.

Using the above syntax you can use the below example formula to calculate the square root of value in Google Sheet :

=SQRT(A2)

Below is the formula which you can use to calculate the cube root of a value in Google Sheets:

=A2^(1/3)

**How to Calculate Square Root and Cube Root in Google Sheets : Step by Step Guide **

Enclosed are the steps to Calculate Square Root and Cube Root in Google Sheets

**How to Calculate Square Root in Google Sheet**

### Step 1 : Prepare your dataset in Google Sheet .

In the below example we have prepared a dataset for which we need to calculate the Square Root.

### Step 2 : Apply the formula **SQRT(value)**

Select the cell where you need to display the Square in our example B2 and apply the formula =**SQRT(value)** which will be =**SQRT**(A2) for our example.

Press Enter

You will get the square of the provided value on the cell B2 ,to apply the formula and get the result for the rest of the numbers ,simply confirm the autofill as shown below.

Now you have the Square root calculated for all the values from Column A which displayed in Column B.

**How to Cube Root in Google Sheet**

To calculate the Cube Root use the following formula **=A2^(1/3)**

Press enter and apply the formula by dragging it downwards across the rest of the cells.

Cube root is calculated for all the selected values as shown above

**How to calculate Nth Root in Google Sheets**

To calculate the nth root of a value in Google Sheet you can use the below formula

=A2^(1/n)

In the below example we are going to calculate the nth root of a value using the formula **=A2^(1/4)**

Press enter and apply the formula across the cells .nth root has been calculated for the selected values as shown below.

**How to Calculate Square Root and Cube Root in Google Sheets(Conclusion)**

In the above tutorial we have provided you the sytax with example to calculate **Square Root and Cube Root in Google Sheets**.We hope this tutorial was helpful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets