WPS Features
Resources
Free AI Tools
Docs Center

How to Use the POWER Function in WPS on Windows

Last updated:July 13, 2026

Use the POWER function through 3 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry point and steps to complete the task.

How-to Index

#TopicMembership
11. Enter POWER through the Insert Function dialog boxFree
22. Type the POWER formula directly in a cellFree
33. Check POWER syntax and parameter detailsFree

How-to Guide

1. Enter POWER through the Insert Function dialog box

Entry point: Formula tab → Insert Function, or the fx button in the formula bar

  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 Formula tab.
  3. Search for POWER in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter the parameters in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • The current cell contains the POWER function.
  • The result is returned after the parameters are filled in.
  • You can continue editing the parameters or copy the formula to other cells.

Tips While Using

  • Search with the English function name POWER.
  • Enter the parameters in the number, power order.

2. Type the POWER formula directly in a cell

Entry point: Cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =POWER(...) directly in the cell or formula bar.
  3. Press Enter to confirm.
  4. If you want to use it across more cells, drag the fill handle to copy the formula.

Success Criteria

  • The cell shows the POWER calculation result.
  • The formula bar shows the full =POWER(...) formula.
  • After filling down or across, the target cells continue calculating correctly.

Tips While Using

  • Use a standard comma to separate parameters.
  • Press Enter after typing the formula.
  • When copying in batches, check whether relative and absolute references match your worksheet layout.

3. Check POWER syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter POWER in the search box.
  3. Select the function to view the syntax POWER(number, power).
  4. Click the help link for this function to view more details.

Success Criteria

  • You can see the POWER function name and syntax format.
  • You can confirm the number of parameters and their order.
  • You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • This is useful when you are not sure how to write the formula correctly.
  • If you already typed a formula in a cell, compare it with the formula bar while checking the syntax.