How to Use Excel Formulas for Multiplication in WPS Office (Easy & Simple)?

August 17, 2023 1.9K views

Welcome to our guide on multiplication formulas in WPS Office Excel. As a powerful and user-friendly spreadsheet software, WPS Office Excel empowers users to perform complex computations effortlessly. In this article, we'll explore the crucial operation of multiplication, its applications in various scenarios, and how to overcome common challenges. Whether you're a beginner or an experienced user, our concise and practical instructions will help you master multiplication formulas and enhance your productivity. Let's dive in and make the most of WPS Office Excel's capabilities!

Part 1: Why are Multiplication Formulas Important in Excel?

In the dynamic world of Excel spreadsheets, multiplication formulas hold paramount significance. They equip users with the ability to conduct a wide range of mathematical operations, from simple number multiplication to complex calculations that combine multiple formulas. This powerful tool automates calculations, bestows accuracy upon results, and amplifies the efficiency of data analysis. Embracing multiplication formulas empowers you to navigate the realm of data with precision and ease, unlocking a world of transformative possibilities.

Part 2. 4 Multiplication Formula in WPS Office

Multiplication is a fundamental operation in WPS Office Excel that allows you to perform various calculations efficiently. In this tutorial, we'll explore four different multiplication formulas using step-by-step instructions, along with helpful examples. Whether you prefer visual aids or written explanations, we've got you covered. Let's get started!

1. Use Asterisk () Symbol

To multiply values in WPS Spreadsheet, simply use the “ * ” symbol between the numbers you want to multiply. Follow these steps:

Step 1: Enter the numbers you want to multiply into separate cells.

Step 2: In an empty cell, type the formula, e.g., "=A1*B1" (without quotes), where A1 and B1 are the cell references.

Step 3: Press Enter to get the result.

Example: If you want to multiply 5 and 10, the formula "=5*10" will give you the result 50.

2. Insert PRODUCT Function

The PRODUCT function in WPS Spreadsheet allows you to multiply a range of numbers quickly. Here's how to use it:

Step 1: Enter the numbers you want to multiply into separate cells.

Step 2: In an empty cell, type "=PRODUCT(A1:A5)" (without quotes) if your numbers are in cells A1 to A5, for example.

Step 3: Press Enter to get the result.

Example: If cells A1 to A5 contain the values 2, 4, 6, 8, and 10, respectively, the formula "=PRODUCT(A1:A5)" will give you the result 3840.

3. Enter SUMPRODUCT Function

The SUMPRODUCT function in WPS Spreadsheet is a powerful tool for multiplying arrays and performing calculations. Follow these steps:

Step 1: Create two arrays of numbers in separate cells.

Step 2: In an empty cell, type the formula, e.g., "=SUMPRODUCT(B3:B6, C3:C6)" (without quotes), where B3:B6 and C3:C6 are the cell ranges containing the numbers you want to multiply.

Step 3: Press Enter to get the result.

Example: If cells B3 to B7 contain the values 1, 2, 3, 4, and 5, respectively, and cells C3 to C7 contain the values 10, 20, 30, 40, and 50, respectively, the formula "=SUMPRODUCT(B3:B7, C3:C7)" will give you the result 550.

4. Using Percentages

Multiplying by percentages is a common operation in Excel. Here's how to do it in WPS Spreadsheet:

Step 1: Enter the number you want to multiply in a cell.

Step 2: Enter the percentage as a decimal (e.g.0.25 for 25%) in another cell.

Step 3: In a third cell, type the formula, e.g., "=A2*B2" (without quotes), where A1 is the cell containing the number and B1 is the cell containing the percentage as a decimal.

Step 4: Press Enter to get the result.

Example: If cell A2 contains the value 100 and cell B2 contains the value 0.25, the formula "=A1*B1" will give you the result 25, which is 25% of 100.

With these four multiplication formulas in your arsenal, you'll be able to perform a wide range of calculations efficiently and accurately in the WPS Spreadsheet. Practice and explore further to become a master at using multiplication formulas!

Recommend WPS Spreadsheet
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Same Excel Formula as Microsoft. Perfectly compatible with MS format.

    Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

Part 3. Why Choose WPS Office?

WPS Office offers essential office applications including Writer, Presentation, and Spreadsheet, covering writing, design, and data analysis tasks. It integrates advanced AI for improved writing and insightful data analysis. Most features are free, with optional premium services, and cross-platform compatibility ensures smooth productivity.

WPS Office's Pros:

Comprehensive Suite: Includes Writer, Presentation, and Spreadsheet for diverse tasks.

AI Enhancement: AI improves writing quality and aids in data analysis.

Free Features: Offers a wide range of functions for free.

Premium Options: Optional premium services like cloud storage enhance user experience.

Cross-Platform Compatibility: Ensures seamless productivity across devices.

In essence, WPS Office provides a versatile suite with AI features and accessibility that cater to various user needs.


1. How to do math on WPS Spreadsheet?

To perform mathematical operations on WPS Spreadsheet, follow these steps:

Step 1: Open WPS Spreadsheet and create a new or open an existing file.

Step 2: Enter the numbers or data you want to use in your calculation into the cells.

Step 3: To add or subtract, use the "+" and "-" symbols between cell references or numbers.

Step 4: For multiplication, use the asterisk "*" symbol, and for division, use the forward slash "/".

Step 5: Parentheses can be used to group operations and control the order of calculations.

Step 6: Press Enter to get the result in the cell.

2. What is the shortcut key for multiplying in Excel?

To multiply in Excel using a shortcut key, follow these steps:

Step 1: Enter the numbers or data you want to multiply into the cells.

Step 2: Select the cell that will contain the result of the multiplication.

Step 3: Press Alt + V (for the "Paste" special menu), then press H (for "Multiply").

Step 4: Finally, press M to complete the "Paste Special" operation for multiplication.

3. How to Multiply in Excel if there's no multiplication formula?

In Excel, there are alternative methods to multiply numbers when a dedicated multiplication formula is unavailable. Here are three ways to achieve multiplication:

·   Using the Asterisk (*) Operator:

Simply type "=" followed by the first number or cell reference.

Then, type "*" (asterisk) and enter the second number or cell reference.

Press Enter to get the result.

·   Using SUM Function:

For multiplying two numbers, type "=SUM(" without quotes.

Enter the first number, "*", then the second number.

Close the brackets and press Enter to get the product.

·   Using Paste Special:

Enter the first number in a cell and copy it (Ctrl + C).

Select the range of cells where you want the result to appear.

Go to "Paste Special" (Ctrl + Alt + V), choose "Multiply," and click OK.


The passage introduces a guide on using Excel multiplication in WPS Office for effortless calculations and data manipulation. It covers formula importance, usage instructions, specific WPS Office formulas, and software benefits. The passage concludes with FAQs and praises WPS Office Excel for its user-friendly power in data analysis and automation.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.