Microsoft Excel logo on a green background

Computing the square root of numbers is common in mathematical equations. If you'd similar to perform that calculation in Microsoft Excel, you lot have a couple of ways to do that. We'll evidence you how.

What Is a Square Root?

The foursquare root of a number is the value that you multiply past 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 Square Root in Excel With the Caret Symbol

One fashion to find the square root in Excel is to use the ^ (caret) symbol. Use this method if you do not want to use a dedicated foursquare root part (which is our second method below).

To start, kickoff, open your spreadsheet with Microsoft Excel. In your spreadsheet, find the number for which you lot want to find the square root.

Find the number to get the square root for.

In the spreadsheet, click the cell in which you lot want to display the resulting square root.

Select a cell to display the square root formula result.

In the selected cell, type the post-obit formula and press Enter. In this formula, replace D2 with the cell where you have your number.

Tip: The ^ (caret) symbol is located on number vi on your keyboard. Press Shift+6 to blazon the symbol.
=D2^(one/2)

Type the square root formula and press Enter.

To directly specify your number in the formula, replace D2 in the formula with your number. Like so:

=225^(i/two)

Enter numbers directly in the square root formula.

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

The answer of the square root formula.

Desire to find the sum of squares in Excel? It'due south equally easy to do that.

RELATED: How to Calculate the Sum of Squares in Excel

Summate Foursquare Root in Excel With the SQRT Role

If you lot'd like to use a function to calculate the square root, utilise Excel'south dedicated SQRT function for finding square roots. This part retrieves the same outcome as the method higher up.

To employ the part, first, open your spreadsheet with Microsoft Excel. In the spreadsheet, select the prison cell in which you want to display the reply.

Select a cell to display the square root function result.

In the selected jail cell, enter the following SQRT role and press Enter. In this function, replace D2 with the cell where your number is.

=SQRT(D2)

Type the square root function and press Enter.

If you wish to directly use the number in the function, and so replace D2 with your actual number. Similar this:

=SQRT(625)

Enter a number directly in the square root function.

Excel will calculate the foursquare root and brandish it in your selected cell.

The result of the square root function.

And that's all.

Bonus Tip: Insert the Foursquare Root Symbol in Excel

By default, both methods above do non display the square root (√) symbol. To add this symbol, you can utilise Excel'south UNICHAR role in conjunction with your preferred foursquare root finding method.

If you employ the caret symbol method to discover the square root, alter your formula as below to add the square root symbol before the answer:

=UNICHAR(8730)&D2^(i/two)

If y'all use the SQRT role, and then modify the function as follows to get in show the foursquare root symbol at the beginning of the answer:

=UNICHAR(8730)&SQRT(D2)

The selected prison cell now displays the symbol before the resulting foursquare root number.

Insert the square root symbol.

And those are the ways to speedily become to the square root of a number. Very useful!

Need to summate something in Excel but non sure what function to use? Excel really makes information technology like shooting fish in a barrel to observe the functions yous demand.

RELATED: How to Find the Function You Need in Microsoft Excel