How to Use the PRODUT Function in WPS on Windows

Last updated:July 20, 2026

Use PRODUT through 3 how-to topics, including entering the function, filling in arguments from syntax prompts, and checking unexpected results.

How-to Index

No.TopicMembership Requirement
11. Enter the PRODUT functionFree
22. Fill in arguments from syntax promptsFree
33. Check the formula when the result looks wrongFree

How-to Guide

1. Enter the PRODUT function

Entry point: WPS Spreadsheets → target cell or formula bar

  1. Open WPS Spreadsheets and go to the worksheet where you want to calculate.
  2. Click the target cell.
  3. Type = to start a formula.
  4. Type PRODUT( to begin the function entry.
  5. Press Enter later after you finish the arguments, or continue editing the formula.

Success Criteria

  • The cell enters formula editing mode.
  • The function text is visible in the cell or formula bar.
  • You can continue entering arguments.

Tips While Using

  • If you do not start with =, the content may be treated as plain text.
  • Make sure the worksheet and cell are editable.

2. Fill in arguments from syntax prompts

Entry point: the active formula in the cell or formula bar

  1. After typing PRODUT(, review the syntax prompt on screen.
  2. Enter the required values or cell references in order.
  3. Separate arguments with commas.
  4. Add the closing parenthesis.
  5. Press Enter to confirm the formula.

Success Criteria

  • The formula is accepted normally.
  • The cell shows a calculation result.
  • You can select the cell again to review or edit the formula.

Tips While Using

  • Missing separators or an unclosed parenthesis can prevent the formula from calculating as expected.
  • The data type in referenced cells can affect the result.

3. Check the formula when the result looks wrong

Entry point: result cell → formula bar

  1. Select the cell that shows the unexpected result.
  2. Review the full formula in the formula bar.
  3. Check the function name, argument count, and reference range.
  4. Edit the formula if needed and press Enter again.
  5. If the result still needs review, reopen the formula and check the referenced content again.

Success Criteria

  • The result updates after the edit, or the formula remains available for further editing.
  • You can continue copying the formula, adjusting references, or saving the workbook.

Tips While Using

  • Referencing text cells or the wrong range can change the result.
  • Protected worksheets may prevent direct formula editing.