How to quickly calculate the square root of a value in Excel?
Have you ever been annoyed with the calculation on square root of multiple values one by one manually? Actually, you can quickly get the square root of values at once with a simple formula in Excel sheet.
Recommended Excel Productivity Tools
Select a blank cell that you will place the result, enter this formula =SQRT(A2), and then drag fill handle down to apply this formula to cells. See screenshot:
In the formula, A2 is the cell you use to calculate the square root.
If you want to replace the numbers with their square roots directly, you can apply Kutools for Excel’s Operation utility.
|Kutools for Excel, with more than 120 handy functions, makes your jobs easier.|
1. Select the numbers you want to calculate, click Kutools > More > Operation. See screenshot:
2. In the Operation Tools dialog, check Function from the left Operation list, select SQRT from the drop-down list in middle section, and you can specify to create formulas or skip formula cells as you need. See screenshot:
3. Click Ok.