How to find the Square Root of a Number in Excel – TheWindowsClub

How to

The Windows Club
TheWindowsClub covers authentic Windows 11, Windows 10 tips, tutorials, how-to’s, features, freeware. Created by Anand Khanse, MVP.
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:
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.
Date:

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.


Windows 11 version 22H2 new features for IT Pros

Windows 11 2022 Update is now available to all

How to Recover Deleted WhatsApp Messages on iPhone and Android with RecoverGo (WhatsApp)

Wondershare MobileTrans v4.0 Review: Transfer, backup, restore data between phones

Copyright © 2022 The Windows Club

source

Leave a Reply

Your email address will not be published.