Multiply a Cell Value by Five with an Excel Formula
Question details
The user wants D15 to show five times the value entered in E15.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Use a formula to calculate a result in D15 from the value in E15.
- Observed behavior
- The desired result increases by five for each whole-number increase in E15: 1 returns 5, 2 returns 10, and 6 returns 30.
Open the worksheet and check that E15 contains a numeric value. Make sure D15 is available for the formula.
Enter a multiplication formula in D15
Use this formula to calculate five times E15 and update the result when E15 changes.
Click cell D15 in the worksheet.
Type =E15*5 in D15 and press Enter.
Enter 6 in E15 and confirm that D15 displays 30. Change E15 to another number to see the result update.

Multiply cell values by five in WPS Spreadsheet
Use the same multiplication formula in WPS Spreadsheet to calculate D15 from E15 and update the result when the input changes.
- 1. Open the spreadsheet: Open WPS Spreadsheet and use Open to select your workbook.
- 2. Enter the input: Click E15 and enter the number you want to multiply.
- 3. Calculate the result: Click D15, type =E15*5, and press Enter.
- 4. Save the workbook: Use File > Save to keep the formula in your workbook.

Frequently Asked Questions
What formula multiplies E15 by five in Excel?
Click D15, enter =E15*5, and press Enter. D15 will display five times the value in E15.
Will the result change when I edit E15?
Yes. With automatic calculation enabled, D15 recalculates when E15 changes. Check Formulas > Calculation Options > Automatic if it does not update.
Can I use the formula for other rows?
Yes. Select D15 and drag its fill handle down. Excel adjusts the relative cell reference, so D16 uses =E16*5.
Can I use the same formula in WPS Spreadsheet?
Yes. Open the workbook in WPS Spreadsheet, select D15, enter =E15*5, and press Enter.




