![]() ![]() This method is more suited when you have a large dataset where you want to calculate the square root of values in a column, and you get a new dataset every day/week/month/quarter. While the above formulas as quick and, if you work with a lot of data and this is something you need to do quite often, you may also consider using Power Query. Getting the Square Root Using Power Query In case you use a negative number in the POWER function, it will return a #NUM error. In case you want the cube root, you can use the below formula: =POWER(100,1/3)Īnd similarly, if you want the square of a number, you can use the same formula with the relevant second argument. ![]() Unlike the SQRT function, you can use the POWER function to calculate the roots (such as square root or cube root) or powers (such as square or cube) of a number.īelow is the formula that will give you the square root of 100 in Excel: =POWER(100,1/2) the power/exponent to which this base number is raised.the base number (could be any real numbers).Calculate Square Root Using the POWER FunctionĪnother easy way to calculate square root in Excel (or cube root or Nth root) is by using the POWER function.īelow is the syntax of the POWER function: =POWER(number,power) This is because the exponential operator gets preference over division and is calculated first. For example, =100^(1/2) and =100^1/2 would give two different results. Important note about brackets: When using the exponential operator with fractions (such as 1/2 or 1/3), make sure these fractions are in brackets. Similarly, you can get the cube root or the Nth root of a number as well.īelow is the formula to get the cube root of 100 =100^(1/3)Īnd below is the formula to get the Nth root of 100 (replace N with any number you want) =100^(1/N) You can also use it to find the square of a number.īelow is the formula that will give you the square root of 100 =100^(1/2) The benefit of using the exponential operator is that you can use it to find the square root, the cube root, or the nth root as well. If all you need is the square root of a number, it’s easier to use the SQRT function. IMSQRT – This function returns the square root of a complex numberĬalculate Square Root Using the Exponential OperatorĪnother way to calculate the square root (or cube root or Nth root) in Excel is by using the exponential operator.SQRTPI – This function returns the square root of a number which has been multiplied by the constant Pi (π).Note: There are two more square root related functions in Excel: For example, if you want to get the square root of -100, you can use SQRT function with the ABS function: =SQRT(ABS(-100))ĪBS function gives you the absolute value and ignores the negative sign. Even if a number is negative, when you multiply it by itself, the result is positive.īut in case you still want the square root of a negative number (assuming it was a positive), you can need to first convert the negative number into a positive one and then find the square root of it. This is understandable as in mathematics, a negative number doesn’t have a square root. While this function works great with positive numbers, if you give it a negative number, it will return a #NUM error. Note: Another result here could be -10, but the formula only returns the positive value. You can also use a cell reference in the SQRT function as shown below: The above formula will give you 10, which is the square root of 100. To calculate the square root of 100 in Excel, you can use the below formula: =SQRT(100) SQRT function takes one single argument (could be the number or reference to the number) and returns the square root of that number. Yes, there is a dedicated function in Excel whose purpose of existence is to give you the square root So let’s get started! Calculate Square Root Using the SQRT function In this tutorial, I will show you a couple of ways (easy ones I promise) to calculate square root in Excel. Here is a detailed article on Wikipedia in case you’re interested in learning more about it. But it’s not so simple to calculate it.įor example, if I ask you to calculate the square root of 50, I am sure you can’t calculate it in your head (unless you’re a math whiz). When you multiply a number (let’s say X) with itself, you get a value (let’s say Y). Inserting the Square Root Symbol (√) in Excel.Getting the Square Root Using Power Query.Calculate Square Root Using the POWER Function.Calculate Square Root Using the Exponential Operator.Calculate Square Root Using the SQRT function. ![]()
0 Comments
Leave a Reply. |