# How to put square root in my microsoft excel data tables? Step by step guide

This **Microsoft software** is mainly characterized by offering a large number of **mathematical**** functions** that you will be able to use every time you work on **your spreadsheets** . So it ends up becoming an excellent alternative when wanting to **work with data and mathematical operations** .

Luckily for everyone, this program has **the root function,** which allows you to know **what the square root of a number x is. **And it is that being able to know this value is very important, since this is a **mathematical calculation that is used very frequently. **In this case, you have **two ways to do** it, either using **Excel’s square root function** or simply doing **the operation manually.**

In accordance with all this, here we are going to explain a little more how you can start **inserting this mathematical operation in each of your work tables. **This will allow you to **get positive values of those numbers that you need** . To do this, follow in detail everything that we will explain in the post.

## Steps to put a square root of a number in an Excel spreadsheet

Taking into account that this is a **mathematical operation** that you will be able to carry out **from Excel**, here we are going to **explain the two ways that you have available to insert the square root of a number in your spreadsheet** .

It is important to remember that this can be done using **the root function or simply manually** .

**To do this, follow each of the methods that we explain below:**

### With the Root Function

The first method that we are going to present you is very simple and fast to achieve, this time it is about **applying the root function provided by the same program** and which has been **created to solve square roots** .

It should be mentioned that only this **function is used to solve this type of operation,** so **the cube, fourth, fifth roots** , among others, are not included in the equation.

**Therefore, in order to perform this mathematical operation, it is necessary to carry out the steps indicated below:**

- The first thing you should do is
**locate yourself in the cell**where you want**the result of the operation**to be reflected . There you must write the following:**= ROOT and the cell to which you want to take the square root**. It will be as follows:**= ROOT (D4).**

- Once this is done, you must press the
**“Enter”**key or click on another**cell to generate the result**.

This is the simplest method you can do to find out what **the square root of a number is in an Excel sheet** . A very useful function that you can use at any time.

### Manually

The other way to find **the square root of a number in Excel** is to carry out **the process manually**, this means that this time **the root function** explained in the previous method will not be used .

**To do this, follow in detail everything that we will teach you below:**

- The first thing you should do is select a
**cell in your Excel spreadsheet.** - There you must write
**the number to which you want to calculate the square root**. Then press**the “Enter” key.**In this case**the number 9**has been written**.** - Now click on another cell where you want
**the square root result to be displayed.** - In this cell you must
**write =**followed by**the cell that contains the number you want to calculate the root of, such**as**C1**and then**^****(1/2).** - Once you have this function
**written in the cell = C1 ^ (1/2)**you must press the**“Enter”**key**,**automatically in this cell you will see the result of**the square root of 9,**it gives the**result 3**.

## Square root of 2 and PI What is the relationship of these functions in Excel?

**The square root of 2 has a value of 1.41421356** …. and many other decimals, this is usually **related a lot to the value of phi which is 1.618033 ..** among many other decimals.

As you can see, both **numbers are very similar**, but the truth is that regarding the relation of **the square root function of two and PI**, many people consider that **the value of PI** is given by **the value of phi,** but also another **large number of users consider that it is given by the value of root of 2.**

However, it is considered that **the PI value is given by the value of the square root of 2,** this is because when **multiplying 2 by the square root of 2** that would be through this function **= 2 * ROOT (2)** which results in **2.8284** …. which generates **polygons from 4 sides to a polygon of 393,216 sides. **So it offers **greater continuity** when explaining where the value of PI comes from.

In this way it can be **ruled out that the value of PI is given by the value of phi**, which is **much less likely to be true** . According to this, it can be said that **the relationship between the square root of 2 and Pi** is that this is given through **the multiplication of 2 by the root of 2,** where **the sum of the values of the polygons is similar to the PI value.**

## Learn how to put other mathematical roots in your Excel spreadsheets

As mentioned earlier in the post, in **the case of Excel it only offers a function to know the square root of two,** so it does not have any other tool that allows you to **develop cube root, fourth root, fifth root operations. ,** among others. To be able to carry out some of them from this **software, it will be necessary to do it from a manual process** .

Keep in mind that this **procedure is very simple to carry out**, that is why here **we are going to show you which are the methods that you must carry out to carry out the mathematical operations of said roots.**

**To do this, follow each of these methods:**

### Cube root

In order to know **the value of the cube root of any number**, you will be able to do it through the **MS program**, remember that in this case **the radication operation has an index of 3.**

**To carry out this operation, you will need to carry out the following steps:**

- For this case we have
**the value of 25**which is located in**cell B1**. Therefore, in**cell E2**you must write the following**: = B1****^ (1/3)**and press the**“Enter”**key**.** - Another way to do this is that in
**cell F2 you**write**= POWER (B1; 1/3).** - Once this is done, the
**result will be 2.92 on the screen**, which represents**the result of the cube root of 25**.

### Fourth root

In the case of **the fourth root, it is the result of the filing operation with index 4.**

**This means that to obtain these results it is necessary that you carry out these steps:**

- Next with the previous example, in
**cell E3**you must write the following:**= B1****^ (1/4).** - Another way is to write the following in
**cell F3**:**= POWER (B1; 1/4).** - Once this is done, it will show you the
**result 2.24,**which is the value of**the fourth root of 25**.

### Fifth root

In the case of **the fifth root, it** is the result of **the mathematical operation of the filing with index 5.**

**To carry out this operation in Excel, you will need to carry out these steps:**

- Continuing with the previous example in
**cell E4**you must write the following:**= B1****^ (1/5).** - You can also do it by writing in
**cell F4**the following**= POWER (B1; 1/5).** - As a result,
**you will be shown 1.90,**which belongs to the**value of the fifth root of 25.**