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)

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).**

### 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