1. Computing

Find the Square Root of Numbers in Excel

Using the SQRT Function in Excel


Finding the Square Root of Numbers in Excel

Finding the Square Root of Numbers in Excel

© Ted French

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.

  1. Enter the following data into cells D1 to D3: 22500, 50625, 90000.

  2. Click on cell E1 in the spreadsheet - this is where the function will be located.

  3. Click on the Formulas tab of the ribbon menu.

  4. Choose Math & Trig from the ribbon to open the function drop down list.

  5. Click on SQRT in the list to bring up the function's dialog box.

  6. In the dialog box, click on the Number line.

  7. Click on cell D1 in the spreadsheet to enter this cell reference into the Number line in the dialog box.

  8. Click OK.

  9. The answer 150 (the square root of 22,500) should appear in cell E1.

  10. Use the fill handle to copy the function in cell E1 to cells E2 and E3.

  11. E2 and E3 should contain the numbers 225 (square root of 50,625) and 300 (square root of 90,000).

  12. When you click on cell E1 the complete function = SQRT ( D1 ) appears in the formula bar above the worksheet.

Other Math Functions
See More About

©2014 About.com. All rights reserved.