How to Multiply the Maximum of the Previous Five Excel Cells by 1.2 in WPS Office
Question details
The user needs an Excel-compatible formula that multiplies the maximum of the five cells immediately to the left by 1.2 and continues to work when copied horizontally across a row.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a row-based calculation and wants the formula to always evaluate the five cells directly to the left of the result cell, including after horizontal copying.
- Observed behavior
- The formula should return 1.2 times the maximum value from the five cells immediately to the left and update to the new previous five cells after copying horizontally.
Open the workbook in WPS Office Spreadsheets and enter the first formula at least five columns to the right of the first data cell, so that five previous cells exist in the same row.
Use =1.2*MAX(B2:F2) with Relative References
Use this solution when the formula starts in G2 or any cell with at least five cells to the left; relative references make the copied formula always target the five immediately previous cells.
The MAX function returns the largest value in the referenced range. Because B2:F2 uses relative references, copying the formula one column to the right changes the range to C2:G2 automatically.
Click cell G2, or the first cell where you want the result to appear.
Type =1.2*MAX(B2:F2) in the formula bar and press Enter.
Drag the fill handle across the columns to copy the formula horizontally.
Select a copied cell and confirm the formula range shifted to the five cells immediately to the left.

Use TAKE and TOROW for a Fixed Range in Dynamic Array Versions
Use this alternative when the data range is fixed and you want to evaluate the last five non-blank values from B2:N2 without adjusting the range.
Build a Previous-Five-Cell Maximum Multiplier in WPS Office Spreadsheets
Enter =1.2*MAX(B2:F2) in WPS Office Spreadsheets and use the fill handle to copy the relative formula across columns. WPS keeps Excel-compatible formula behavior and file formats.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the Excel-compatible file that contains the row data.
- 2. Select the result cell: Click the first result cell, such as G2, ensuring at least five data cells are to its left.
- 3. Enter the formula: Type =1.2*MAX(B2:F2) in the formula bar and press Enter.
- 4. Drag the fill handle: Use the fill handle in the lower-right corner of the cell to copy the formula horizontally across the row.
- 5. Verify the copied formulas: Click a copied cell and confirm that the range automatically moved to the five cells immediately to its left.

Frequently Asked Questions
How does =1.2*MAX(B2:F2) calculate the result?
It first finds the largest number in cells B2 through F2 with MAX, then multiplies that value by 1.2.
Why does the formula update to =1.2*MAX(C2:G2) after copying?
Because the cell references are relative. When you copy the formula one column to the right, every referenced cell also moves one column to the right.
Can I change 1.2 to another multiplier?
Yes. Replace 1.2 with another number or a cell reference, for example =$H$1*MAX(B2:F2) if the multiplier is stored in H1.
What if my data range has blank cells between values?
The simple MAX approach includes blanks but ignores them in the maximum calculation. If you must skip blanks while choosing exactly the last five values, use a dynamic array formula with TOROW and TAKE in a compatible version.
Is this formula compatible with Microsoft Excel?
Yes. The =1.2*MAX(B2:F2) formula works in WPS Office Spreadsheets and Microsoft Excel because it uses standard MAX and relative references.




