Multiply Two Cells in Excel with a Basic Formula
Question details
Use a basic formula to multiply values stored in two separate Excel cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to multiply values such as 50,000 and 80 in a worksheet.
- Observed behavior
- A formula in a third cell should display the product of the two values.
Identify the cells containing the two values and make sure they contain numbers rather than text. Choose an empty cell for the result.
Multiply two Excel cells with the asterisk operator
Use a cell-reference formula to calculate the product and update it when either value changes.
Enter 50000 in cell A1 and 80 in cell B1, or identify the cells that already contain your values.
Select an empty cell, such as C1, and type =A1*B1. Replace A1 and B1 with your actual cell references if needed.
Press Enter. For 50000 and 80, the result is 4,000,000.
If the formula returns an error, select the input cells and check that they contain numeric values. If Excel flags a number stored as text, select the warning icon and choose Convert to Number, then check the result again.

Multiply cell values in WPS Spreadsheets
Use the same multiplication formula in WPS Spreadsheets to calculate a product from two cells.
- 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
- 2. Enter the values: Type 50000 in A1 and 80 in B1, or locate the cells containing your values.
- 3. Add the formula: Select an empty cell, such as C1, and type =A1*B1, adjusting the references as needed.
- 4. View the product: Press Enter to display the result. For these example values, the product is 4,000,000.

Frequently Asked Questions
What symbol multiplies two cells in Excel?
Use an asterisk (*). For example, enter =A1*B1 in an empty cell and press Enter.
Will the result change if I edit an input cell?
Yes. A formula such as =A1*B1 references the cells, so the result normally recalculates when either value changes.
Why does my multiplication formula return an error?
Check the error message and inspect both input cells for nonnumeric text. If Excel flags a number stored as text, select the warning icon and choose Convert to Number.
Why can I see the formula instead of the answer?
The formula cell may be formatted as text. Select it, choose General on the Home tab, then press F2 and Enter to re-enter the formula.




