In this Excel tutorial, you will learn the basics of calculating several types of roots of a number such as

– Square root.

– Cubic root.

– Any order (**Nth**) root.

We have used Microsoft 365 while preparing this article but the methods in this article are applicable in other versions as well.

The **Nth** root of a number is the number that has the power of **1/Nth**. Like, if I say, the **4th** root of **100**, it means **100** to the power of **¼ (100 ^{1/4})**. There are several built-in functions in Excel that allow you to calculate the root of a number. Such as

**SQRT**,

**POWER**,

**SERIESSUM**, and

**IMPOWER**functions. We have shown the uses of these functions to calculate roots in Excel.

**Download Practice Workbook**

**Table of Contents**Expand

## How to Calculate Square Root in Excel?

We will be using the following dataset as an example to illustrate methods of calculating square root in Excel.

### 1. Calculate Square Root Using Circumflex (^) Symbol

You can express roots using the **Circumflex(^)** symbol. Like, if I say **5 ^{2}**, you can express this as

**5^2**. Usually, button

**6**on your keyboard contains this symbol. To write this symbol, simply use

**Shift + 6**. You can use this symbol to calculate the square root of a number as well.

- In the following dataset, select cell
**C5**. - Then apply the formula below and press
**Enter**. - After that, use the
**Fill Handle**icon to drag down.

`=B5^(½)`

### 2. Compute Square Root Applying SQRT Function

First, let’s get familiar with **the SQRT function** in Excel. Using Excel’s built-in **SQRT **function, you can calculate the square root of a number.

- To use this function, select cell
**C5**, apply the formula below and press**Enter**. - After that, drag down using the
**Fill Handle**icon.

`=SQRT(B5)`

### 3. Calculate Square Root Employing POWER Function

You can calculate the square root of a number using **the POWER function** in Excel. Let’s have a look at the overview of the **POWER **function.

- Now, we will show you how to use this function.
- Activate cell
**C5**, copy and paste the formula below, and press**Enter**. - Then use the
**Fill handle**to drag down.

`=POWER(B5,0.5)`

### 4. Determine Square Root Using SERIESSUM Function

With the help of Excel’s built-in **SERIESSUM **function, you can calculate the square root of a number. This function is used to calculate the sum of a power series. The syntax of the **SERIESSUM **function is as follows:

**=SERIESSUM(x, n, m, coefficients)**

Here, **x**= the input value to the power series

**n**= the initial power to which you want to raise x

**m**= the step by which to increase n for each term in the series

We will now use this formula to calculate the square root of a number.

- Select cell
**C5**. - Insert the below formula and press
**Enter**. - Use the
**Fill handle**to drag down.

`=SERIESSUM(B5,1/2,0,1)`

### 5. Calculate Square Root Using the Combination of EXP and LN Functions

In Excel, the natural exponential **e **is expressed as **the ****EXP function**. The logarithm which has base **e** is known as natural logarithm **ln**. This **ln** is expressed as **the ****LN function** in Excel. Using these two functions **EXP** and **LN**, you can calculate the square root of a number as well.

- Select cell
**C5**. - Apply the formula below and press
**Enter**. - After that, drag down using the
**Fill handle**icon.

`=EXP(LN(B5)/2)`

__Formula Breakdown__

**LN(B5)/2**

The **LN** function here calculates the natural logarithm value that is in **cell B5**. After that, the result is divided by **2**.

**EXP(LN(B5)/2)**

The **EXP **function calculates the exponential value of the result.

### 6. Calculate Square Root Using Power Query Feature

Using Excel’s **Power Query** feature, one can calculate the roots of numbers from a range quickly and precisely. We will use the Power Query to add a column named “Square Root” beside our existing dataset and then calculate the square root of the numbers.

- First, select the range
**B5:B9**. - At the toolbar, go to the
**Insert**tab. - Click on
**Table**.

- Mark the
**My table has headers**box. - Click on
**OK**.

- A table will be formed as follows.
- Click anywhere on the table and go to the
**Data**tab. - Select
**From Table/Range**.

- A new window titled
**Power Query Editor**will appear on your worksheet. - Go to the
**Add Column**tab and click on**Custom Column**.

- Name the new column as
**Square Root**(or whatever you want). - In the
**Custom column formula**section, insert the following formula below and click on**OK**.

`=Number.Sqrt([Number])`

- After that, within the
**Power Query Editor**window, follow these steps:**Home >>****Close & Load****>>****Close & Load**.

- A new worksheet will be created as follows where you will see the square roots of all the numbers from the previous range
**B5:B9**.

## How to Calculate Cube Root in Excel?

Cube root means the power of **⅓**. If I say cube root of **10**, it means **10 **to the power **⅓**, (**10 ^{1/3}**). In Excel, you can also calculate the cube root of any number.

- In the following dataset, select cell
**C5**. - Insert the formula below and click on
**Enter**. - Then use the
**Fill Handle**icon to drag-down.

`=POWER(B5,⅓)`

## How to Calculate Nth Root in Excel?

The **Nth** root of a number is the number that has the power of **1/Nth**. If I say, the **10th **root of **100**, it means **100 **to the power **1/10** (**100 ^{1/10}**). Using Excel’s built-in

**POWER**function, you can determine the

**Nth**root of any number. Here, we will be calculating the

**5th root**of several numbers.

- Select cell
**C5**and type down the formula below and then press**Enter**. - Drag down using the
**Fill Handle**to get the**5th**root of other values.

`=POWER(B5,⅕)`

## How to Calculate Roots of Complex Numbers in Excel?

A complex number consists of two parts: the real part and the imaginary part. If I call out a complex number like **5+2i**, then **5** is the real part and **4i** is the imaginary part.

In Excel, you can calculate the roots of complex numbers also, using **IMSQRT **or **IMPOWER** functions. These are built-in functions in Excel.

**1. Calculate Roots of Complex Numbers with the IMSQRT function**

Let’s assume, you want to calculate the square root of a complex number which is in cell **B5** in the following dataset.

- Select cell
**C5**. - Insert the formula below and press
**Enter**.

`=IMSQRT(B5)`

This is the square root of the given complex number.

**2. Using the IMPOWER Function**

Similarly, you can calculate the cube root of a complex number as well in Excel.

- Suppose, you have a complex number in cell
**B5**. - Activate cell
**C5**. - Apply the formula below and press
**Enter**.

`=IMPOWER(B5,⅓)`

Using this **IMPOWER **function, you can calculate the **Nth **root of any complex number.

**Note: **The format of the complex number should be: **real part + imaginary part**. You have to input the real part first.

## Frequently Asked Questions

**1. How do you write root 3 in Excel?**

Root **3** means the **power of ⅓**. It can be said as a **cubic root**. Like if I say the cubic root of **8**, it means **8** to the power **⅓** (**8 ^{1/3}**). In Excel, you can write root

**3**using the

**circumflex(^)**symbol. If you want to write root

**3**of

**8**then simply write

**8^(⅓)**. A circumflex symbol between

**8**and

**⅓**.

**2. How do you do the 10th root in Excel?**

**The 10th** root means the **power of 1/10**. Let’s assume, you want to calculate the **10th **root of **1024**. This means you have to calculate the value of **1024 ^{1/10 }**(

**1024**to the power

**1/10**). You can do this calculation in several ways in Excel. One of them is using the

**POWER**function. Suppose, you have the value

**1024**in

**cell A1**. Select any empty cell and apply this formula:

`=POWER(A1,1/10)`

This will return **2** in the cell you have applied the formula.

**3. What does √ mean in Excel?**

In Excel, **√** means square root. If I say **√4**, it means **4** to the power of **½**. In Excel, you can calculate the square root of a number using the **SQRT** function. Let’s assume, you have a value of **4** in **cell A1**. Select any empty cell and apply this formula to calculate the square root of **4**:

`=SQRT(A1)`

This will return **2** in the selected cell.

## Conclusion

In Excel, one can quickly and precisely determine the roots of integers or complex numbers by using a number of built-in functions such as **SQRT**, **POWER**, **SERIESSUM**, etc. In this article, we have demonstrated the use of those built-in functions to calculate the root in Excel.

Hope you have got whatever you were looking for. Have a visit to our site **ExcelDemy** to explore more relevant articles. Thank you.

## Root in Excel: Knowledge Hub

**<< Go Back to | Excel for Math | Learn Excel**