For example, to square the number 5, i.e. In Microsoft Excel, the caret symbol (^) acts as the exponent, or power, operator. For this, you use the caret character (^), which is located above the number 6 on most keyboards. Though, it's not possible to type that traditional square root symbol in Excel, there is a way to find square root without any function. When calculating by hand, you write square root by using the radical symbol (√). How to do square root in Excel using a calculation In case you wish to take a square root of a negative number as if it were a positive number, wrap the source number in the ABS function, which returns the absolute value of a number ignoring the sign: Why's that? Since there is no way to square a number and get a negative result. It happens because the square root of a negative number does not exist among the set of real numbers. ![]() ![]() If a number is negative, like in rows 7 and 8 in the screenshot above, the Excel SQRT function returns the #NUM! error. To calculate square root of a number in A2, use this one: =SQRT(A2) Where number is the number or reference to the cell containing the number for which you want to find the square root.įor example, to get a square root of 225, you use this formula: =SQRT(225)
0 Comments
Leave a Reply. |