How to calculate the square root in Excel

How to calculate the square root in Excel

Calculating the square root of numbers is common in mathematical equations. If you want to do that calculation in Microsoft Excel, you have a couple of ways to do it. We will show you how.

What is a square root?

There square root of a number is the value you multiply by itself to get the original number. For example, the square root of 25 is 5. This is because if you multiply 5 by 5, you get 25.

Calculate the square root in Excel with the caret symbol

One way to find the square root in Excel is to use the ^ (caret) symbol. Use this method if you don’t want to use a dedicated square root function (which is our second method below).

To get started, first open your spreadsheet with Microsoft Excel. In your spreadsheet, find the number for which you want to find the square root.

Find the number to get the square root for.

In the spreadsheet, click the cell where you want to see the resulting square root.

Select a cell to view the result of the square root formula.

In the selected cell, type the following formula and press Enter. In this formula, substitute D2with the cell where you have your number.

Suggestion: the ^ (caret) symbol is located on the number 6 on the keyboard. Press Shift + 6 to type the symbol.

=D2^(1/2)

Type the square root formula and press Enter.

To directly specify your number in the formula, substitute D2in the formula with your number. Like this:

=225^(1/2)

Enter the numbers directly into the square root formula.

And instantly, Excel will display the resulting square root in the selected cell.

The answer of the square root formula.

Calculate the square root in Excel with the SQRT function

If you want to use a function to calculate the square root, use the SQRTdedicated Excel function to find square roots. This function retrieves the same result as the previous method.

To use the function, first open your spreadsheet with Microsoft Excel. In the spreadsheet, select the cell where you want to view the answer.

Select a cell to view the result of the square root function.

In the selected cell, enter the following SQRTfunction and press Enter. In this function, replace D2with the cell where your number is.

=QUADRATO(D2)

Type the square root function and press Enter.

If you want to use the number directly in the function, substitute it D2with your actual number. Like this:

=QUADRATO(625)

Enter a number directly into the square root function.

Excel will calculate the square root and display it in the selected cell.

The result of the square root function.

And this is all.

Bonus tip: insert square root symbol in Excel

By default, both of the above methods do not display the square root symbol (√). To add this symbol, you can use the UNICHARExcel function in combination with your preferred square root search method.

If you use the caret symbol method to find the square root, please modify the formula as below to add the square root symbol before the answer:

=UNICAR(8730)&D2^(1/2)

If you use the SQRTfunction, modify it as follows to make it show the square root symbol at the beginning of the answer:

=UNICAR(8730)&QUADRATO(D2)

The selected cell now shows the symbol before the resulting square root number.

Enter the square root symbol.

And these are the ways to quickly get to the square root of a number. Very helpful!

Similar Posts

Leave a Reply

Your email address will not be published.