Calculate 25 Percent of the Sum of Two Cells in Excel
Question details
Calculate 25 percent of the sum of two cells using an Excel formula.

- 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.
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.
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.
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.
Type =0.25*(A1+B1), replacing A1 and B1 with your source cell references. You can also use =25%*SUM(A1,B1).
Press Enter. The result updates when either source value changes.

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. Open a spreadsheet: Open WPS Office, select Spreadsheets, and open an existing workbook or create a blank one.
- 2. Choose the source cells: Enter or locate the two values you want to add, such as the values in A1 and B1.
- 3. Enter the formula: Click an empty cell and type =0.25*(A1+B1), replacing the references with your own cells.
- 4. Calculate and save: Press Enter to calculate the result, then use File > Save to save the workbook.

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.




