How to put cos in the square in Excel

How to calculate the square root in Excel?

Microsoft Excel software has a wide range of math functions that can help you solve complex problems. A number of simple actions - addition, multiplication, and others - is very easy to perform, using special characters. However, there are those that require a special description - well, not everyone knows how to calculate the square root in Excel.

What is the root of the square?

Before beginning the learning process of how to find the square root to Excel, you should familiarize yourself with the fact that this is a math function. By definition, a square root is a number - a number whose square is equal to the number one. Not just square roots in mathematical science. They come in every other degree too, so the square root is often referred to as the second degree root.

Root function

In solving the problem with finding the place assigned root "Eksele" get the desired results in several ways. Functionality of the program allows you to use both the built-in manufacturing algorithms, and write it yourself, using special theorems and properties of the root. The easiest way to find the answer is to use the square root function. In Excel, it can be accessed by opening the Options menu or typing it manually.

The syntax is very simple - after using one of the functions specified (equal sign) it is necessary to register the keyword "root", which indicates the call the corresponding command. Next, in parentheses will be the variable from which you want to take the square root. In Excel, the argument of the function can be used as an explicit numerical value and a reference to a cell, and a mathematical expression that takes the value of a number.

With the help of mathematical properties

The square root in Excel lets you calculate a number of other methods that require deep knowledge not in the mathematical sciences. It is enough to know what root is - this topic was touched on in the first section of the article. With the definition of a square root, it can be expressed as the reciprocal powers of two required numbers. So, to get the square root without using the "root", you can simply raise the number to an output.

This can also be done in two ways. The first is to use the other functions - "stage". It increases the specified number or the result of a math expression to a selected degree. In this case, the "degrees" indicate the number of 1/2 or 0.5. Any number is possible to a certain extent and without the use of functions - "Eksele" is a special character responsible for this process: "^". In this case, the square root is obtained by enclosing sufficient expression in parentheses, followed by the addition of "^ (1/2)" or "* (0.5)." The result of this action will be the construction of the force with be similar to the function and use of the "root" function.

It should be noted that the method of making a root to find potentization is more convenient. The reason for this is the fact that with the help of these operations you cannot get roots without applying special additional calculations.


Finally, to deal with how to calculate the square root to Excel, consider a few examples of the two methods described above.

In the first case we use the "root" function, call it up with the "Insert Function" key. In the window that will enter the data for calculation, such as the difference between the values ​​of two cells, and then click "OK".

In the second case, find a human-readable version, with an explicit assignment of a service, of the following expression for the square root of a number, for example 9:

The result of this action will be set to "3".