Square root in Excel | excel root square
ThetutorialshowshowtodosquarerootinExcelaswellashowtocalculateNthrootofanyvalue.Squaringanumberandtakingasquarerootareverycommonoperationsinmathematics.ButhowdoyoudosquarerootinExcel?EitherbyusingtheSQRTfunctionorbyraisinganumbertothepowerof1/2.Thefollowingexamplesshowfulldetails.HowtosquarerootinExcelusingSQRTfunctionTheeasiestwaytodosquarerootinExcelisbyusingthefunctionspeciallydesignedforthis:SQRT(number)Wherenumberisthenumberorreferencetothecellcontainingthenumberforwhichyouwanttofindthe...
The tutorial shows how to do square root in Excel as well as how to calculate Nth root of any value.
Squaring a number and taking a square root are very common operations in mathematics. But how do you do square root in Excel? Either by using the SQRT function or by raising a number to the power of 1/2. The following examples show full details.
How to square root in Excel using SQRT functionThe easiest way to do square root in Excel is by using the function specially designed for this:
SQRT(number)
Where number is the number or reference to the cell containing the number for which you want to find the square root.
For example, to get a square root of 225, you use this formula:
=SQRT(225)
To calculate square root of a number in A2, use this one:
=SQRT(A2)
If a number is negative, like in rows 7 and 8 in the screenshot above, the Excel SQRT function returns the #NUM! error. It happens because the square root of a neg...