While using MS Excel, you may require to compute square root of of a large data. Microsoft Excel has a plethora of functions, which can help you to compute mathematical operations in a single click. For example, you can calculate sum of elements of a row of different columns, or square, multiplication, division, square root, cube root, any power, etc.

In this article, I will show you some simple tips which will help beginner Excel users to compute square root easily. In case you don’t know what square root is. Here is an example. Square of a number means the number multiplied by itself. So, square of 5 is 25. This means, square root of 25 is 5. Square of 7 is 49. This means square root of 49 is 7 and so on.

Steps To Calculate Square Root In Microsoft Excel

Method 1: Using Power Formula

As discussed before, that you can compute power of any number using Excel functions. To find square root, simply replace the power by 1/2 or 0.5.

=POWER(number,power)

Example =POWER(36,1/2) and hit Enter

How To Calculate Square Root In Microsoft Excel

You can also insert the cell value instead number

How To Calculate Square Root In Microsoft Excel?

Method 2: Using SQRT function

=SQRT(number or cell value)

That’s very simple.

How To Calculate Square Root In Microsoft Excel?

Method 3: Using Carat (^) operator

The Carat operator in MS Excel enables you to raise any number’s base value using power or exponent. It is similar as h=the POWER function.

=Cell value or number ^(1/2)
How To Calculate Square Root In Microsoft Excel?

That’s all! Hope the article helped you.

About 

Happiness is that best therapy. Use it to heal yourself and then others!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.