Function Problems

How to Calculate a 3 Percent Cost Increase Formula in Excel

Natalie Taylor Oct 1, 2026 868 views

Question details

The user needs to calculate a 3 percent increase on an existing value to accurately project future expenses like employee benefit costs.

How to Calculate a 3 Percent Cost Increase Formula in Excel

Product: Excel
Device & OS: not provided
Scenario: Projecting annual employee benefit costs by applying a percentage increase to the previous year's base value.
Observed behavior: A formula is required to automatically calculate and output the increased financial amount based on a reference cell containing the original cost.

Before you start

Ensure the cell containing your original baseline value is formatted correctly as a number or currency before applying the percentage multiplier.

Solution 1Recommended

Use a Decimal Multiplier for a 3% Increase

The most standard and calculation-friendly way to calculate a 3 percent increase is by multiplying the original value by a decimal factor of 1.03.

In financial modeling, adding a percentage to a base amount can be done in one step by multiplying the original amount by 1 plus the decimal equivalent of the percentage. For a 3 percent increase, this multiplier is 1.03.

Select the target cell

Click on the cell where you want the projected cost to appear, such as cell C13.

Enter the formula

Assuming B13 contains your original value (e.g., $27,560), type =B13*1.03 directly into the cell or the formula bar above.

Apply the calculation

Press the Enter key to execute the formula. The result will instantly reflect the 3 percent addition.

Use a Decimal Multiplier for a 3% Increase

Format as Currency: To display the result properly as money, select your new cell, navigate to the Home tab, and choose the Currency or Accounting format from the Number format dropdown list.

Solution 2

Use the Percentage Operator

You can also use the percentage sign directly within your multiplication formula for a visually intuitive calculation.

Efficient Spreadsheet Calculations

Easily Calculate Percentage Increases with WPS Spreadsheet

WPS Office Spreadsheet provides all the standard formulas, formatting tools, and financial functions you need to calculate percentage increases, track budgets, and project business costs seamlessly.

1. Open your dataset in WPS: Launch WPS Office and open your spreadsheet file containing the baseline cost data.
2. Input the multiplier formula: Select an empty cell and enter the formula =B13*1.03 or =B13*103% to apply the 3% increase to your referenced cell.
3. Format the output: Right-click the calculated cell, choose 'Format Cells', and select 'Currency' to properly display the financial projection.

Fully compatible with Microsoft Excel (.xlsx) file formats and formulasBuilt-in intuitive number formatting for currencies and percentagesLightweight, fast, and completely free to useAdvanced formula support for complex financial modeling and projections

microsoft office alternative - wps office

Frequently Asked Questions

How do I calculate a different percentage increase, like 5% or 10%?

To calculate a different percentage increase, simply change the multiplier in your formula. For a 5% increase, multiply the cell by 1.05 (or 105%). For a 10% increase, multiply by 1.10 (or 110%).

How can I apply this 3% increase formula to an entire column of data?

Enter the formula in the first target cell and press Enter. Then, click the small green square at the bottom-right corner of that cell (the Fill Handle) and drag it down the column to automatically apply the formula to the rest of the rows.

Why is my formula returning a plain decimal instead of a currency value?

Spreadsheet cells inherit standard formatting unless otherwise specified. To fix this, select the cell, navigate to the Home tab on your ribbon, and select 'Currency' or 'Accounting' from the Number Format dropdown menu.

Can I reference a cell containing the percentage instead of typing it manually?

Yes. If cell A1 contains '3%', you can write the formula as =B13*(1+A1). Be sure to lock the percentage reference by using absolute references (like $A$1) if you plan to drag the formula down to other rows.

Excel & Data Problems