Q:

# How do you calculate square root in Excel?

A:

To calculate the square root of a number in Microsoft Excel, enter "=SQRT(number)" into a blank cell. You can also set up side-by-side columns using the Excel worksheet function, where you can enter a number in one column and the square root appears in the column next to it.

## Keep Learning

Credit: Blend Images/Hill Street Studios Vetta Getty Images

1. Set up the output column

To set up the output column, type "=SQRT(" into a blank cell, and use your mouse to left-click the cell immediately to the left of the cell you are typing in. Complete the function by typing ")." An example of a formula might be "=SQRT(A1)" if you are typing in cell B1.

2. Copy the formula

Click on the cell that you have set up with the square root function. Click Edit and then Copy. Select any number of rows below the copied cell. Click Edit and then Paste Special. Select Formula. The formula is pasted and applied to all selected cells.

3. Enter the original numbers

Enter the numbers that you want to find the square root for in the column immediately to the left of the column with the square root formulas. Only positive numbers may be entered. The square root of each number immediately appears in the output column.

Sources:

## Related Questions

• A: Microsoft Excel is important because it is the basic spreadsheet program used in Windows, which means a large number of computers in the world use it. This... Full Answer >
Filed Under:
• A: The formula to find the remainder when dividing one number by another in Microsoft Excel is =MOD(first number, second number). For example, =MOD(17,3) retu... Full Answer >
Filed Under:
• A: The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is... Full Answer >
Filed Under:
• A: You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, ... Full Answer >
Filed Under:
PEOPLE SEARCH FOR