Function Problems

Multiply a Cell Value by Five with an Excel Formula

Natalie TaylorNatalie Taylor Nov 18, 2026 869 views

Question details

The user wants D15 to show five times the value entered in E15.

Multiply a Cell Value by Five with an Excel Formula
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.
Before you start

Open the worksheet and check that E15 contains a numeric value. Make sure D15 is available for the formula.

Solution 1Recommended

Enter a multiplication formula in D15

Use this formula to calculate five times E15 and update the result when E15 changes.

1
Select the result cell

Click cell D15 in the worksheet.

2
Enter the formula

Type =E15*5 in D15 and press Enter.

3
Check the result

Enter 6 in E15 and confirm that D15 displays 30. Change E15 to another number to see the result update.

Enter a multiplication formula in D15
Calculate with WPS Spreadsheet

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. 1. Open the spreadsheet: Open WPS Spreadsheet and use Open to select your workbook.
  2. 2. Enter the input: Click E15 and enter the number you want to multiply.
  3. 3. Calculate the result: Click D15, type =E15*5, and press Enter.
  4. 4. Save the workbook: Use File > Save to keep the formula in your workbook.
Calculate five times a cell value with a simple formulaOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet started with a free, lightweight office suite
microsoft office alternative - wps office

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.