Function Problems

Calculate 25 Percent of the Sum of Two Cells in Excel

Steven ParkerSteven Parker Nov 18, 2026 870 views

Question details

Calculate 25 percent of the sum of two cells using an Excel formula.

Calculate 25 Percent of the Sum of Two Cells in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants a result that updates when either source cell changes, including in an Excel worksheet embedded in a Word document.
Observed behavior
The result cell should display one quarter of the combined values of the two source cells.
Before you start

Identify the two cells containing the numbers and choose an empty cell for the result. If the worksheet is embedded in Word, double-click it to activate Excel editing.

Solution 1Recommended

Multiply the sum of two cells by 25 percent in Excel

Use a simple formula to calculate one quarter of two values, whether the worksheet is standalone or embedded in Word.

1
Select the result cell

In the Excel worksheet, click an empty cell where you want the result to appear. If the worksheet is embedded in Word, double-click it first to activate editing.

2
Enter the formula

Type =0.25*(A1+B1), replacing A1 and B1 with your source cell references. You can also use =25%*SUM(A1,B1).

3
Calculate the result

Press Enter. The result updates when either source value changes.

Multiply the sum of two cells by 25 percent in Excel
Display the result as a number: The formula returns an amount, not a percentage rate. If it appears as a percentage, select the result cell and choose General or Number from the number format menu on the Home tab.
Calculate with WPS Spreadsheets

Calculate 25 Percent of Two Cells in WPS Spreadsheets

Use the same arithmetic formula in WPS Spreadsheets to calculate one quarter of two cell values and update the result as the values change.

  1. 1. Open a spreadsheet: Open WPS Office, select Spreadsheets, and open an existing workbook or create a blank one.
  2. 2. Choose the source cells: Enter or locate the two values you want to add, such as the values in A1 and B1.
  3. 3. Enter the formula: Click an empty cell and type =0.25*(A1+B1), replacing the references with your own cells.
  4. 4. Calculate and save: Press Enter to calculate the result, then use File > Save to save the workbook.
Calculate 25 percent of a sum with a simple formulaOpen and edit Microsoft Excel XLSX filesUpdate results automatically when source values changeUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

What formula calculates 25 percent of two cells in Excel?

Enter =0.25*(A1+B1) in an empty cell, replacing A1 and B1 with your actual cell references. You can also use =25%*SUM(A1,B1).

Can I use this formula in an Excel worksheet embedded in Word?

Yes. Double-click the embedded worksheet in Word to activate editing, select an empty cell, and enter the formula.

Will the result change if I edit a source cell?

Yes. The formula recalculates when either referenced value changes, provided Excel's calculation mode is set to Automatic under Formulas > Calculation Options.

Why does my result appear as a percentage instead of an amount?

The result cell may be formatted as a percentage. Select it and choose General or Number from the number format menu on the Home tab.