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