Excel Formula to Multiply by the Larger of Two Values
Question details
Multiply a value by whichever of two comparison cells contains the larger number.

- 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.
Identify the cell containing the value to multiply and the two cells to compare. Make sure the comparison cells contain numeric values.
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.
In Excel, click the cell where you want the multiplication result to appear.
Type =A3*MAX(F5,F6), replacing A3, F5, and F6 with your own cell references if needed.
Press Enter. Excel displays the value in A3 multiplied by the larger value in F5 or F6.

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. Open your spreadsheet: Open WPS Spreadsheets and select your workbook.
- 2. Select a result cell: Click the cell where you want to display the result.
- 3. Enter and calculate the formula: Type =A3*MAX(F5,F6), adjust the cell references as needed, and press Enter.

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.




