How to calculate square root in Excel?

Microsoft Excel has a wide set of mathematical functions to solve difficult tasks. A number of simple operations - addition, multiplication and others do very easily, using the special characters. However, there are those that require a special description - so, not everyone knows how to calculate square root in Excel.

What is the square root?

Before starting the process, how to find square root in Excel, is a closer look at what is this mathematical function. By definition, the square root of a number a is a number whose square is equal to the number. In the mathematical Sciences can be found not only square roots. They also come in any other degrees, so the square root is often called the root of the second degree.

Root Function

When solving a problem related to finding square root in Excel, to get the desired result in several ways. The functionality of the program allows to use built-in algorithms decisions, and to write it themselves using the special theorems and properties of the root. The easiest way of finding the answer is the square root function. In Excel it can be called by opening the options menu or by typing manually.

The syntax of the function is very simple - after you specify the use of one of the functions (the equal sign) you must specify the key word "ROOT" meaning the call to the appropriate team. Then in brackets have to record the variable from which you want to extract the square root. In Excel as the function argument can be used as an explicit numeric value or a cell reference, as well as a mathematical expression, whose result is a number.

Recommended

"Knowledge is light and ignorance is darkness": the value, meaning and alternatives

There are some sayings that would seem to need no explanation, such as “teaching & ndash; light and ignorance – darkness”. But some still do not understand their meaning. But not only for such people is written by our article. I...

What was invented by Mendeleev for the army. The history and fate of the invention

D. I. Mendeleev was a brilliant Russian scientist-polymath, who made many important discoveries in various fields of science and technology. Many people know that he is the author of “Fundamentals of chemistry" and the periodic law of chem...

The origin of the Slavs. The influence of different cultures

Slavs (under this name), according to some researchers, appeared in the story only in 6 century ad. However, the language of nationality bears the archaic features of the Indo-European community. This, in turn, suggests that the origin of the Slavs h...

Using mathematical properties

The square Root in Excel, you can calculate a number of other methods that do not require deep knowledge in the mathematical Sciences. It is enough to know what is root, this subject was discussed in the first section of the article. Using the definition square root, it can be represented as an inverse power of two of the desired numbers. Thus, to obtain the square root without using function "ROOT" is possible, just raising to a power.

This can be Done also in two ways. The first is to use another function - the "DEGREE". She builds the specified number or the result of a mathematical expression in the selected degree. In this case the column "Degree" to indicate the number of 1/2 or 0.5. To build any number in a certain degree is possible without using any functions in "Excel" is a special character in charge of this operation: "^". In this case, to obtain the square root, it is sufficient to enclose the expression in parentheses, after which add "^(1/2)" or "^(0,5)". The result of this action will be similar to the exponentiation with the function and use the function "ROOT".

It Should be noted that a method of finding a root with exponentiation is more convenient. The reason for this is the fact that using these operations, you can obtain the root of any degree, without using any special additional calculations.

Examples

To completely understand how to calculate square root in Excel, you should consider a couple of examples for the two methods described above.

In the first case, use the function "ROOT" by calling it with the button "Insert function". In the opened window will remain to specify the data to calculate, for example, the difference between the values of two cells, and click "OK".

In the second case, using a more readable version, with the clear assignment of powers of, we get the following expression for finding square root of a number, for example 9:

The Result of this action will be the value of "3".