Multiply Two Cells in Excel and Show the Result in Another Cell
Question details
Multiply the values in cells A2 and A3 and show the result in cell A4.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs a worksheet formula that calculates the product of two cell values in a separate result cell.
- Observed behavior
- Cell A4 should display the product of the numbers entered in A2 and A3.
Make sure cells A2 and A3 contain numbers, and confirm which cells hold the values you want to multiply. Select the result cell before entering the formula so the calculation is placed in the correct location.
Enter a multiplication formula in cell A4
Use this method to calculate the product of the values in A2 and A3 and display it automatically in A4.
Excel uses an asterisk (*) as the multiplication operator. The result in A4 updates whenever you change either source value.
Click cell A4, where you want the multiplication result to appear.
Type =A2*A3 in cell A4 or in the Formula Bar.
Press Enter. Excel calculates the values in A2 and A3 and displays their product in A4.
If the first value is in A1 instead of A2, click A4 and change the formula to =A1*A3, then press Enter.
Multiply Cell Values in WPS Spreadsheets
WPS Spreadsheets lets you enter the same multiplication formula to calculate values in separate cells. Select the destination cell, enter the cell references with an asterisk, and WPS updates the result as your source values change.
- 1. Open the worksheet in WPS Spreadsheets: Open your spreadsheet file in WPS Office and select the worksheet containing the values in A2 and A3.
- 2. Select the output cell: Click cell A4 to set the location for the calculated product.
- 3. Type the multiplication formula: Enter =A2*A3 directly in cell A4 or in the formula input bar.
- 4. Press Enter to apply the formula: Press Enter to display the product in A4 and keep it linked to the values in A2 and A3.
Frequently Asked Questions
What formula multiplies the values in cells A2 and A3?
Select the result cell and enter =A2*A3, then press Enter.
Why does Excel show a formula instead of the multiplication result?
The cell may be formatted as Text. Select the cell, choose Home > Number Format > General, then re-enter =A2*A3 and press Enter.
Can I multiply cells located in different columns?
Yes. Use the relevant references, such as =B2*C2, in the cell where you want to show the product.
How do I multiply a cell by a fixed number in Excel?
In the result cell, enter a formula such as =A2*10. Replace 10 with the fixed number you need.
