How to extract square root in excel. How to calculate square root in Excel? Raising to a power using an operator

Extracting the root of a number is a fairly common mathematical operation. It is also used for various calculations in tables. IN Microsoft Excel There are several ways to calculate this value. Let's take a closer look at the various options for implementing such calculations in this program.

There are two main ways to calculate this indicator. One of them is suitable exclusively for calculating the square root, and the second can be used to calculate the value of any degree.

Method 1: Applying a Function

In order to extract the square root, a function is used, which is called the ROOT. Its syntax looks like this:

ROOT(number)

In order to use this option, it is enough to write this expression in a cell or in a line of program functions, replacing the word "number" with a specific number or with the address of the cell where it is located.

To perform the calculation and display the result on the screen, press the button ENTER.

In addition, you can apply this formula through the function wizard.

As a result, the result of calculations will be displayed in the specified cell.

You can also call the function through the tab "Formulas".

Method 2: exponentiation

=(number)^1/3

That is, formally, this is not even extraction, but raising the value to the power of 1/3. But this degree is the cube root, so it is precisely such an action in Excel that is used to obtain it. In this formula, instead of a specific number, you can also enter the coordinates of a cell with numeric data. The entry is made in any area of ​​the sheet or in the formula bar.

Do not think that this method can only be used to extract the cube root from a number. In the same way, you can calculate the square and any other root. But only in this case you will have to use the following formula:

=(number)^1/n

n is the degree of elevation.

Thus, this option is much more versatile than using the first method.

As you can see, despite the fact that Excel does not have a specialized function for extracting the cube root, this calculation can be carried out using raising to a fractional power, namely 1/3. You can use a special function to extract the square root, but it is also possible to do this by raising a number to a power. This time it will be necessary to raise to the power of 1/2. The user himself must determine which method of calculation is more convenient for him.

It is known for making life much easier for people who regularly solve various problems in it. Very often, users need to calculate the roots of numbers in order to get the desired result. In order not to do this separately and independently, you can complete such a process in a fairly short time without leaving the program document.

Let's consider what ways there are in Excel for raising a degree and calculating square roots.

Calculation from one or more numbers

You can extract the square root of a specific value in a table editor by entering the root value in the 1st cell of the table. Using the mouse cursor, you need to select the desired cell and type a number in its field, then confirm the action by pressing the "Enter" button.

Then you should select the 2nd cell, where the root will be subsequently displayed. After that, on the toolbar (at the top of the editorial document), you need to find the “fx” (“Insert Function”) button and click on it - the “Function Wizard” window will appear, where you need to select the “ROOT” category. If this category is not in the list presented, a search engine will help you find it.

After confirming the choice, the next window "Function Arguments" will pop up, in which you should enter the number of the first cell in the "Number" field. You can do this either manually or with the mouse. When the program has received all the values, calculations will be made automatically.

After the extraction process with one digit has been successfully completed, you can change the original value, with which a new calculation will take place again.

Very often in Excel it is required to derive square roots not for two data, but for more. If each time for a separate cell to repeat the entire procedure described above, then the result will be the same time costs as when calculating manually. However, the program took into account this nuance.

You can quickly calculate the root of several numbers if you follow the instructions:

1. First, numerical values ​​are entered into the column, which will be subjected to calculations.
2. In another column, preferably next to it, you need to do everything that was previously described, that is, actions for the first two data in the list.
3. The obtained values ​​in the cells must be highlighted.
4. After that, you need to move the mouse cursor to the lower right corner of the selection, where a cross will appear, which should be dragged with the left button to the end of the column.
5. The adjacent column will display, after the steps taken, the results of calculations for all selected cells of the 1st column.

Extracting a root of any degree

Calculating square roots in the Microsoft Excel text editor is easy, and the benefits of the knowledge gained will delight every time this kind of task occurs. However, this is not all: consider how you can calculate the root of any number.

We will conditionally take “n” as the value of the degree. More mathematics lessons taught us that extracting the root of the degree "n" equals the number raised to the power of "1/n". You can raise to a power in Excel using the symbol called the cap (“^”), which is located on the keyboard at number 6 in the English layout.

To calculate from the value located in cell B2, you must enter in the line Excel formulas the following data: \u003d B2 ^ (1/2) (see photo). And to extract the third degree: =B2^(1/3). Thus, you can extract any root from any number.

Microsoft Excel has a wide range of mathematical functions that allow you to solve complex problems. A number of simple actions - addition, multiplication and others - are very easy to perform using special symbols. However, there are those that require a special description - for example, not everyone knows how to calculate in Excel.

square?

Before you start learning the process of how to find the square root in Excel, you should take a closer look at what this mathematical function is. By definition, the square root of a is some number whose square is equal to a. IN mathematical sciences not only square roots can be found. They also come in any other degree, so the square root is often called the root of the second degree.

Root function

When solving a problem related to finding a square, there are several ways to get the desired result. The functionality of the program allows you to both use the built-in solution algorithms, and write it yourself, using special theorems and properties of the root. The simplest way to find the answer is the square root function. In Excel, it can be called by opening the function menu or by manually entering it.

The syntax of the function is very simple - after specifying the use of one of the functions (equal sign), you must write the keyword "ROOT", indicating the call of the corresponding command. Next, in parentheses, it remains to write the variable from which you want to extract the square root. In Excel as a function argument can be used explicitly numerical value, and a reference to a cell, as well as some mathematical expression, the result of which is a number.

Using mathematical properties

The square root in Excel can be calculated by a number of other methods that do not require deep knowledge in mathematical sciences. To do this, it is enough to know what a root is - this topic was touched upon in the first section of the article. Using the definition of a square root, it can be represented as the inverse power of two of the desired number. Thus, you can get the square root without using the "ROOT" function by simply raising the number to a power.

This can also be done in two ways. The first is to use another function - "DEGREE". It raises the specified number or the result of a mathematical expression to the selected power. In this case, it is necessary to indicate the number 1/2 or 0.5 in the "Degree" column. It is possible to raise any number to a certain degree without using any functions - Excel provides a special symbol responsible for this operation: "^". In this case, to get the square root, it is enough to enclose the expression in brackets, after which add "^(1/2)" or "^(0.5)". The result of this action will be similar to exponentiation using the function, as well as using the "ROOT" function.

It should be noted that the method of finding the root c is more convenient. The reason for this is the fact that with the help of these operations it is possible to obtain a root of any degree without applying any special additional calculations.

Examples

To finally understand how to calculate the square root in Excel, it is worth considering a couple of examples for the two methods described above.

In the first case, we will use the "ROOT" function by calling it using the "Insert function" button. In the window that opens, it remains to specify the data for calculation, for example, the difference between the values ​​of two cells, and click "OK".

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

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

We continue the review of mathematical functions and possibility. Today, the next step is the formula from the simplest - the degree in Excel. Exponentiation (root) by a function or simple notation, negative power. How beautiful to write down the degree will also be here. Everything is simple in principle, but this does not mean that you do not need to write an article about it. Moreover, I did not find one large article covering all questions on degrees. So read this article here:

We all know that the degree means multiplying the same numbers, as many times as the degree of the number. Those. 2 to the power of 3 = 8 = 2 * 2 * 2.

The degree of a number can be written in two ways

1. POWER function
2. ^ icon

POWER function in Excel

The syntax for this function is simple.

POWER(number, degree)

The number is the number to be raised to the power, in our example it is 2.

The degree is, accordingly, the degree itself, i.e. 3

Recording the degree using the ^ symbol

A good and fast thing in Excel, if you need to quickly use the degree in calculations, use the ^ symbol. Everything is written simply, in the cell enter = 2 ^ 3

Not difficult.

Negative exponent in spreadsheet editor

A negative degree is an expression written like this formula a - n \u003d (1 / a n). Simply put, 2 to the power - 3 \u003d one eighth (1/8 \u003d 1/2 ^ 3)

Writing such a formula should also not cause problems. Lots of options

1/POWER(2;3)=1/(2^3)=POWER(2;-3)=2^-3

How do you like it better?

How to find the root of a number in Excel? Function Root

As we know that the square root of a number is a number to the power of 0.5 (1/2). Therefore, finding the root of a number is as simple as raising it to any power. If you want to extract the root of 2 from four, then write down = POWER (4; 0.5). Or there is a special function for this = ROOT (Number). I show several ways to extract the root of a number at once.

How to beautifully write down the degree in Excel in the caption for calculations?

Now let's talk about how to beautifully write signatures for formulas. By a beautiful record, we mean the so-called. superscript font. Like here:

It is very simple to do this, select a number in the formula bar or in a cell that indicates the degree (what needs to be made small).

To calculate the square root of a number in the spreadsheet editor Microsoft Excel, you must first enter the root value in the first cell of the table. To do this, use the mouse cursor to select the desired cell and enter a number in its field. After completing the input, press the "Enter" button on the keyboard, which will mean the end of the operation and allow the computer to process the entered information.

Next, select the second cell in which you want to place the root value, and on the toolbar at the top of the editor window, find the fx button (when you hover over it with the mouse cursor, the inscription "Insert function" will pop up). After clicking this button, in the "Function Wizard" window that appears, select the "ROOT" category in the corresponding field (if it is not displayed, find it using the search engine here).

In the next window "Arguments of functions" in the field "number" you need to enter the number of the first cell (containing the root value). This can be done in two ways: manually by entering an alphanumeric designation (for example: A1) or by clicking on the desired cell with the mouse. After that, the program will automatically calculate the value of the root. Now, even if you change the original value, the root number will be recalculated for the new number.

Calculating the square root for a series of numbers

Let's say that you need to calculate the square root not for one or two, but for a much larger number of values. Repeating all the steps indicated in the previous paragraph for each number is no less tedious than manually counting and entering data. And Excel wouldn't be such a great editor if this point wasn't taken into account.

What actions need to be taken in this case? Enter in the column or row the numbers whose root you want to calculate. In the next column (row), perform all the steps indicated in the previous paragraph of the article for the first two numbers in the list. Select the cells with the resulting values. Move the cursor over the square in the lower right corner of the selection until the cursor turns into a "+" sign. Press the left mouse button and drag the cursor to the end of the column (row). You have two parallel columns (rows): with radical expressions and their values.