Function Problems

How to Multiply the Maximum of the Previous Five Excel Cells by 1.2 in WPS Office

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

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.

How to Multiply the Maximum of the Previous Five Excel Cells by 1.2 in WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the first result cell

Click cell G2, or the first cell where you want the result to appear.

2
Enter the formula

Type =1.2*MAX(B2:F2) in the formula bar and press Enter.

3
Copy across the row

Drag the fill handle across the columns to copy the formula horizontally.

4
Check the updated ranges

Select a copied cell and confirm the formula range shifted to the five cells immediately to the left.

Use =1.2*MAX(B2:F2) with Relative References
Result: If G2 contains =1.2*MAX(B2:F2), copying it to H2 updates the formula to =1.2*MAX(C2:G2).

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. 1. Open the workbook: Launch WPS Office Spreadsheets and open the Excel-compatible file that contains the row data.
  2. 2. Select the result cell: Click the first result cell, such as G2, ensuring at least five data cells are to its left.
  3. 3. Enter the formula: Type =1.2*MAX(B2:F2) in the formula bar and press Enter.
  4. 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. 5. Verify the copied formulas: Click a copied cell and confirm that the range automatically moved to the five cells immediately to its left.
Uses the same MAX and relative reference logic as Microsoft Excel.Maintains full compatibility with .xlsx and other Excel file formats.Provides a familiar formula bar, fill handle, and spreadsheet layout for quick editing.Runs as a free, lightweight Office alternative without requiring a subscription.Supports horizontal copying so the previous-five-cell rule stays intact.
microsoft office alternative - wps office

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.