Formula Errors

How to Multiply Two Calculations in One Excel Formula

Camila MilosovichCamila Milosovich Nov 18, 2026 869 views

Question details

Combine two calculations and multiply their results in a single Excel formula.

How to Multiply Two Calculations in One Excel Formula
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to multiply the result of subtracting one cell from another by the result of dividing a third cell by 5.
Observed behavior
A single formula should calculate both expressions and return their product.
Before you start

Identify the cells used in each calculation and confirm they contain numeric values. The example below uses B13, C13, and D13; replace those references with your own if needed.

Solution 1Recommended

Multiply the Two Calculations with Parentheses

Use parentheses to group each calculation before multiplying their results.

1
Select the result cell

In Excel, click the empty cell where you want the result to appear.

2
Enter the formula

Type =(B13-C13)*(D13/5) in the selected cell or formula bar. Replace the cell references if your values are elsewhere.

3
Calculate the result

Press Enter. Excel subtracts C13 from B13, divides D13 by 5, and multiplies the two results.

Multiply the Two Calculations with Parentheses
Equivalent shorter formula: You can also use =(B13-C13)*D13/5. Multiplication and division have the same precedence and are evaluated from left to right.
Spreadsheet formulas

Multiply Calculations in WPS Spreadsheet

Use the same cell references, parentheses, and multiplication operator in WPS Spreadsheet to combine both calculations in one formula.

  1. 1. Open your spreadsheet: Launch WPS Spreadsheet and open your workbook, or create a new spreadsheet.
  2. 2. Select a result cell: Click the cell where you want to display the combined calculation.
  3. 3. Enter the formula: Type =(B13-C13)*(D13/5) in the cell or formula bar, adjusting the references to match your sheet.
  4. 4. Show the result: Press Enter to calculate the product.
Combine multiple calculations in a single formulaOpen and save Microsoft Excel XLSX and XLS filesEdit formulas in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why do I need parentheses around B13-C13?

Parentheses make Excel calculate B13-C13 before multiplying. Enter =(B13-C13)*(D13/5) to group the subtraction and division explicitly.

Can I write the formula without parentheses around D13/5?

Yes. Enter =(B13-C13)*D13/5. Excel evaluates multiplication and division from left to right, producing the same result.

What if my values are in different cells?

Replace B13, C13, and D13 in the formula with your own cell references. For example, use =(A1-B1)*(C1/5) if the values are in A1, B1, and C1.

Will the same formula work in WPS Spreadsheet?

Yes. Select a cell in WPS Spreadsheet, enter =(B13-C13)*(D13/5), and press Enter.