This tutorial covers finding the square root of numbers in Excel. It includes a step by step example of finding square roots in Excel using the SQRT function.

The syntax for the SQRT function is:

**= SQRT ( Number )**

Number - the number for which you want to find the square root - can be a number or a cell reference.

### Example Using Excel's SQRT Function:

For help with this example, see the image above.

- Enter the following data into cells D1 to D3: 22500, 50625, 90000.
- Click on cell E1 in the spreadsheet - this is where the function will be located.
- Click on the
*Formulas*tab of the ribbon menu. - Choose
**Math & Trig**from the ribbon to open the function drop down list. - Click on
*SQRT*in the list to bring up the function's dialog box. - In the dialog box, click on the
*Number*line. - Click on cell D1 in the spreadsheet to enter this cell reference into the Number line in the dialog box.
- Click OK.
- The answer 150 (the square root of 22,500) should appear in cell E1.
- Use the fill handle to copy the function in cell E1 to cells E2 and E3.
- E2 and E3 should contain the numbers 225 (square root of 50,625) and 300 (square root of 90,000).
- When you click on cell E1 the complete function
**= SQRT ( D1 )**appears in the formula bar above the worksheet.

**Other Math Functions**