3 different ways to find the Square Root of a Number in Excel

Microsoft Excel is a powerful tool to carry out complex calculations. If you work on Excel, then you might come across performing mathematical operations almost every day. Sometimes, we face problems to do simple calculations in Excel and to find square root in Excel is one among them. So, in this article, I will let you know of 3 different ways to find the square root of a number in Excel.

Calculate Square Root of Number in Excel

Using SQRT function, POWER function and Exponential formula, it is easy to calculate the square root of a number in Excel easily.

1. Use SQRT Function To Find Square Root of A Number In Excel

Excel provides SQRT function to find the square root of a number. It is easy to use and you just need to pass the number or reference of a cell which has a number to SQRT function.

Syntax:

SQRT(number)

Calculate Square Root of Number in Excel

But, there is a small problem with using SQRT directly. If you pass the negative number to SQRT function, then it shows #NUM! error.

So, it is always recommended to use ABS function along with SQRT function as shown below.

ABS function converts negative number to positive number i.e; absolute number.

2. Use POWER Function To Find Square Root of A Number

POWER function helps you to find the square root of a number in a different way when compared to SQRT function. Using this function, we find a square root of a number by raising the number to the Nth power.

Syntax:

POWER (number, power)

Here, the number refers to the number directly or cell reference which has a number to find the square root and power is the exponent to raise the number to that power.

As we want to find the square root of a number in Excel, we can use power as ‘1/2’ and the formula becomes POWER (number, 1/2).

find square root of a number in excel using power function

3. Use Exponent Operator to Find Square Root of A Number

Using Exponent Operator to find a square root of a number is easy when compared to above two methods. This is similar to POWER, but here we do not use any function, but just an exponent operator.

Exponent operator allows us to raise the number to any power. To find the square root of a number in Excel, we use ‘(1/2)’ as the exponent. So, if we have the number in cell ‘B2’ then, B2^(1/2) gives square root of a number available in cell B2.

These are 3 different ways to find the square root of a number in Excel easily. Please share with us if you have any other methods and let us know if you have any more questions.

Read next: How to calculate Sporadic Totals in Microsoft Excel.

Posted by on , in Category Office with Tags
Sridhar is a Software Engineer who loves to stay updated with developments in the world of technology. He is fond of writing everything related to Internet, Computers and Mobile and Desktop Operating Systems.