WPS Features
Resources
Free AI Tools
Docs Center

How to Use the MMULT Function in WPS on Windows

Last updated:July 13, 2026

Use the MMULT function with 3 how-to topics, all available without membership, and jump to the steps you need from the How-to Index.

How-to Index

#TopicMembership
11. Enter MMULT from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. View function syntax and argument detailsFree

How-to Guide

1. Enter MMULT 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 MMULT in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each argument in the Function Arguments dialog box.
  6. Click OK to finish entering the formula.

Success Criteria

  • UI state: The MMULT formula appears in the selected cell or in the formula bar.
  • Next actions: You can continue editing arguments, confirm the result, or copy the formula.

Tips While Using

  • Common mistakes: A misspelled function name can make MMULT harder to find.
  • Environment limits: WPS Sheets must already be open in a worksheet.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =MMULT(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review the syntax, type =MMULT( and press F1 to view the prompt.

Success Criteria

  • UI state: The formula is entered in the target cell.
  • Next actions: You can continue adjusting references and checking the calculation result.

Tips While Using

  • Common mistakes: Incorrect parentheses, separators, or reference ranges can affect the result.
  • Environment limits: The array dimensions in the arguments must satisfy matrix multiplication rules.

3. View function syntax and argument details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter MMULT in the search box.
  3. Select the function to review the syntax MMULT(array1, array2).
  4. Click the help link for the function to view more details.

Success Criteria

  • UI state: The MMULT syntax and argument area are visible.
  • Next actions: You can continue inserting the function or editing the formula based on the guidance.

Tips While Using

  • Common mistakes: If the wrong function is selected first, the displayed argument details will not match MMULT.
  • Environment limits: An internet connection is needed when opening the help link.