How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

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)

How to use Column and Columns Formu...
How to use Column and Columns Formula in Excel | Excel Tutorial For Beginners | Lesson - 21

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


Calculate Square Root Cube Root Google Sheets

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

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets