How to Use the SQRT Function in WPS on Windows

This how-to guide covers 3 topics for using the SQRT function in WPS Sheets on Windows, and all 3 are available without membership.

How-to Index

How-to Guide

1. Enter SQRT from the Insert Function dialog box

Entry point: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for SQRT in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter the argument in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• The current cell contains the SQRT function.
• The full formula is visible in the formula bar.
• The worksheet returns the corresponding square-root result.

Tips While Using

• The argument should be a valid number or a numeric cell reference.
• If the argument is negative, the result may return an error value.
• You can search with either uppercase or lowercase sqrt to confirm the function.

2. Type the formula directly in a cell

Entry point: Worksheet cell or formula bar

1. Select the cell where you want to enter the formula.
2. Type =SQRT(...) directly in the cell or in the formula bar.
3. Replace the content inside the parentheses with the target number or cell reference.
4. Press Enter to confirm.
5. If you want to use it across more rows, drag the fill handle to copy the formula.

Success Criteria

• The cell displays the square-root result.
• When the cell is selected, the formula bar shows =SQRT(...).
• After copying the formula to other cells, the corresponding results continue to appear.

Tips While Using

• Use English parentheses and the English function name when typing the formula.
• If the referenced cell does not contain a valid number, the result may be incorrect.
• When filling down, pay attention to the difference between relative and absolute references.

3. Review the function syntax and parameter details

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter SQRT in the search box.
3. Select the function and review the syntax SQRT(number).
4. Review the parameter description to confirm the argument meaning and input method.
5. If a help link is available in the interface, open it for more details.

Success Criteria

• You can see the SQRT function name and syntax format.
• You have confirmed the number of arguments and what the argument means.
• You can return to the worksheet and continue entering the formula.

Tips While Using

• Syntax review is useful when you want to confirm the argument format before formal entry.
• If the result looks wrong, first check whether the argument is numeric and whether a negative number was entered.