How to find square root in Excel

You can watch a video tutorial here.

Excel is a great tool for calculations and provides many functions and operators to support all basic mathematical operations. When performing calculations, you may need to find the square root of a number. You can do this using the following functions:

1. SQRT(): this returns the square root of a number
   1. Syntax: SQRT(number)
      1. Number: the number for which the square root is to be found
2. POWER(: returns a number raised to the exponent:
   1. Syntax: POWER(number, exponent)
      1. number: the number to be raised
      2. exponent: the power to which the number is to be raised

Option 1 – Use the SQRT() function

Step 1 – Create the formula

• Select the destination cell
• Type the formula using cell references:

=SQRT(number)

• Press Enter

Step 2 – Copy the formula

• Using the fill handle from the first cell, drag the formula to the remaining cells

OR

1. Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
2. Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)

Option 2 – Use the POWER() function

Step 1 – Create the formula

• Select the destination cell
• Type the formula using cell references:

=POWER(Number,1/2)

• Press Enter

Step 2 – Copy the formula

• Using the fill handle from the first cell, drag the formula to the remaining cells

OR

1. Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
2. Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)