Function Problems

Multiply Two Cells in Excel with a Basic Formula

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 869 views

Question details

Use a basic formula to multiply values stored in two separate Excel cells.

How to Multiply Two Cells in Excel
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.
Before you start

Identify the cells containing the two values and make sure they contain numbers rather than text. Choose an empty cell for the result.

Solution 1Recommended

Multiply two Excel cells with the asterisk operator

Use a cell-reference formula to calculate the product and update it when either value changes.

1
Enter the values

Enter 50000 in cell A1 and 80 in cell B1, or identify the cells that already contain your values.

2
Enter the formula

Select an empty cell, such as C1, and type =A1*B1. Replace A1 and B1 with your actual cell references if needed.

3
Calculate the result

Press Enter. For 50000 and 80, the result is 4,000,000.

4
Check any errors

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 two Excel cells with the asterisk operator
Formula displayed instead of a result?: Select the formula cell, change its format to General on the Home tab, then press F2 and Enter to re-enter the formula.
Calculate in WPS Spreadsheets

Multiply cell values in WPS Spreadsheets

Use the same multiplication formula in WPS Spreadsheets to calculate a product from two cells.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
  2. 2. Enter the values: Type 50000 in A1 and 80 in B1, or locate the cells containing your values.
  3. 3. Add the formula: Select an empty cell, such as C1, and type =A1*B1, adjusting the references as needed.
  4. 4. View the product: Press Enter to display the result. For these example values, the product is 4,000,000.
Multiply values with familiar cell-reference formulasOpen and edit Microsoft Excel XLSX and XLS filesUpdate the result when either input value changesUse WPS Office for free
microsoft office alternative - wps office

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.