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
