Function Problems

Excel Formula to Multiply by the Larger of Two Values

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 869 views

Question details

Multiply a value by whichever of two comparison cells contains the larger number.

Multiply by the Larger of Two Values in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains a value to multiply and two cells whose values need to be compared.
Observed behavior
The formula should select the larger comparison value and multiply it by the original value.
Before you start

Identify the cell containing the value to multiply and the two cells to compare. Make sure the comparison cells contain numeric values.

Solution 1Recommended

Use MAX to Multiply by the Larger Value in Excel

Use this formula when the value is in A3 and the two comparison values are in F5 and F6.

MAX(F5,F6) returns the larger of the two values, and the multiplication operator applies it to A3.

1
Select the result cell

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

2
Enter the formula

Type =A3*MAX(F5,F6), replacing A3, F5, and F6 with your own cell references if needed.

3
Calculate the result

Press Enter. Excel displays the value in A3 multiplied by the larger value in F5 or F6.

Use MAX to Multiply by the Larger Value in Excel
Check copied formulas: Cell references change when you copy the formula. Use references such as $F$5 and $F$6 if those comparison cells must stay fixed.
WPS Spreadsheets

Multiply by the Larger Value in WPS Spreadsheets

Use the same MAX formula in WPS Spreadsheets to compare two cells and multiply by the larger value.

  1. 1. Open your spreadsheet: Open WPS Spreadsheets and select your workbook.
  2. 2. Select a result cell: Click the cell where you want to display the result.
  3. 3. Enter and calculate the formula: Type =A3*MAX(F5,F6), adjust the cell references as needed, and press Enter.
Compare two values with the MAX functionOpen and save Microsoft Excel XLSX filesWork with familiar spreadsheet formulas and cell references
microsoft office alternative - wps office

Frequently Asked Questions

How do I multiply by the smaller value instead?

Use =A3*MIN(F5,F6). The MIN function selects the smaller of the two comparison values.

Can I compare more than two cells?

Yes. Use a range such as =A3*MAX(F5:F10) to multiply A3 by the largest value in cells F5 through F10.

How do I keep the comparison cells fixed when copying the formula?

Use absolute references: =A3*MAX($F$5,$F$6). The comparison references remain fixed when you copy the formula to another cell.

Does this formula work in WPS Spreadsheets?

Yes. Select a result cell in WPS Spreadsheets, enter =A3*MAX(F5,F6), and press Enter.