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.
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:
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 .
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 .
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.