In this tutorial, we will learn 3 easy ways to calculate the square root of a number in Excel. It will be a very common calculation that you’ll perform very often if you work with large mathematical datasets of any kind. So let’s get started.
Different Ways to Calculate the Square Root in Excel
There are many different ways you can use to calculate square roots and here are some of the most common ones.
1. SQRT() function
Excel provides an inbuilt mathematical function SQRT to calculate the positive square root of a number.
Syntax: SQRT(n). Here n is the number or cell reference which contains the number for which you want the square root.
When the SQRT function is applied to a negative number, #NUM! error message is returned.
We can avoid the #NUM! error message, use the ABS function to find the absolute value of the number and then calculate the square root.
2. POWER() Function
The POWER function returns the result of a number raised to a power. Syntax: POWER(n,power), where n is the base number or cell reference which contains the base number and power is the exponent to which the base number is raised. This function can be utilized to find the square root of a number by keeping power as 0.5 or (1/2).
3. Using the Caret ^ operator
We can use the caret operator ^ to raise a number to the power of half (1/2 or 0.5) and get the square root of the number.
Syntax: n^(1/2) or n^0.5, where n is the number or cell reference which contains the number for which you want the square root.
As you can see, we have the square root in the column B using the caret operator.
Excel provides a direct function SQRT to calculate the square root of a number. There are other simple methods to do the same which are discussed above. We hope you learned something new today!