Raise Percentage in Excel and Google Sheets

Spreadsheets are where offer letters, merit grids, and manager worksheets meet. This guide is the spreadsheet companion to how to calculate a raise — it does not replace that pillar. Use the salary increase percentage calculator to double-check a cell, then keep sibling reading on how raise budgets are set when a percent came from a pool.

Why a raise percentage Excel formula belongs next to the guide

The pillar page teaches the math in words. Teams still paste numbers into Excel or Google Sheets. A wrong denominator, mixed hourly and annual cells, or a percent typed as 5 instead of 5% silently skews every downstream paycheck view. The formulas below are copy-paste safe when you keep units consistent.

Core raise percentage Excel formula

Assume B2 is old pay and C2 is new pay (same period):

=(C2-B2)/B2

Format the result as a percentage. For a whole-number display:

=(C2-B2)/B2*100

That is the same identity as the guide: raise % = (new − old) ÷ old × 100. Never subtract in the opposite order if you want a positive raise when pay went up.

New pay from a known percent

If B2 is current pay and D2 is the raise as a percent (for example 5% or 0.05):

=B2*(1+D2)

Dollar increase only:

=B2*D2

Percent from old and new when HR rounds dollars

Offers often round to the nearest $100. Store the posted new salary in C2 and compute the true percent with =(C2-B2)/B2 rather than assuming the intended round percent. Compare that cell to the intended rate so you can see rounding drift.

Monthly and hourly conversions in the same workbook

Keep a period label in column A. Convert annual to monthly with =annual/12, biweekly with =annual/26, and hourly with =annual/(hoursPerWeek*weeksPerYear). Apply the raise on the annual row first, then derive periods so you do not raise an hourly cell and an annual cell with different percentages by mistake.

Example layout:

| Label | Old | New | Raise % | | Old annual | 72000 | 74880 | =(C2-B2)/B2 | | Monthly | =B2/12 | =C2/12 | (same %) | | Biweekly | =B2/26 | =C2/26 | (same %) | | Hourly (40×52) | =B2/2080 | =C2/2080 | (same %) |

Google Sheets notes

Google Sheets accepts the same formulas. Use Format → Number → Percent on the raise cell. Named ranges (old_pay, new_pay) improve shared templates. Protect formula columns so collaborators edit inputs only.

Worked table you can paste

Common spreadsheet mistakes

Typing 5 when the cell is not formatted as percent multiplies by 500% if you write 1+D2 expecting 5%. Prefer 1+D2 with a true percent cell, or 1+D2/100 when D2 is a whole number. Mixing an hourly old rate with an annual new salary breaks the denominator. Copying a raise percent from a peer without converting currencies or pay periods creates false precision.

Template checklist for managers

1. One input block: old pay, intended %, optional rounded new pay.
2. Computed true % from rounded new pay.
3. Period table driven only from annual.
4. Note field for effective date (back pay is separate — see the back pay calculator when live).
5. Link out to how to calculate a raise for narrative steps teammates can read without opening the file.

When to leave the spreadsheet

Use the interactive salary increase percentage calculator for quick what-ifs, inflation sketches, and shareable result links. Keep Excel for batch merit grids and audit trails. For tax-bracket myths after a percent change, read does a raise push you into a higher tax bracket.

Bottom line

A raise percentage Excel formula is only trustworthy when units match and percent cells are true percents. Paste the identities above, lock formulas, and send readers to the how-to pillar for the conceptual walkthrough — this post stays the spreadsheet layer, not a second formula essay.

Building a reusable raise workbook

Start with three sheets: Inputs, Employee grid, and Audit. Inputs holds hours per week, weeks per year, default currency, and a named inflation assumption if you sketch real raise. The employee grid has one row per person: employee ID, old annual, intended percent, rounded new annual, computed true percent, dollar raise, monthly, biweekly, and a notes column for exceptions such as mid-cycle promotions. The audit sheet lists checksums: sum of dollar raises, average intended percent, average true percent, and count of rows where absolute true-minus-intended exceeds 0.15 percentage points.

Named ranges reduce formula drift when you insert columns. In Excel, Formulas → Name Manager; in Sheets, Data → Named ranges. Name hours_week, weeks_year, and annual_hours (=hours_week*weeks_year). Hourly cells then read =annual/annual_hours instead of hard-coded 2080, so part-year schedules stay honest.

Conditional formatting that catches errors

Flag any true percent below 0 (pay cut) in amber and any true percent above 25% in a review color unless the row is tagged promotion. Flag blank old pay. Flag rows where new pay is less than old pay but intended percent is positive — that usually means a paste error. These rules do not replace human review; they surface the rows that waste a calibration meeting.

Percent vs percentage-point language in cells

Comment headers carefully. A move from 3% to 5% is a two percentage-point change, not a 2% raise on pay. If a cell stores the change in the raise rate itself, label it pp_change so nobody multiplies salary by that field. Salary raise math always multiplies pay by (1 + raise_rate).

Sharing Sheets with finance without leaking drafts

Use a view-only link for leadership decks and keep edit access on a short list. Strip employee names from screenshots. If you paste calculator share URLs into a cell, remember those URLs embed pay figures — treat the sheet like a compensation document in storage policies.

Mapping spreadsheet outputs to offer letters

Offer letters need currency, pay basis, and effective date. Pull TEXT(new_annual,"$#,##0.00") for letter mail merge carefully, and keep a plain-number column for HRIS imports that reject currency formatting. When a letter states an hourly rate, regenerate it from annual with the same annual_hours named range used in the grid so letter and HRIS match.

Cross-checking with the public calculator

Pick three random rows, enter old and new into the salary increase percentage calculator, and confirm the percent matches your true-percent column within 0.01 points. If share links are enabled, store them in an audit column for later dispute resolution. Differences almost always trace to mismatched periods or a percent typed as a whole number.

From spreadsheet to conversation

Numbers do not replace evidence. When an employee asks how a cell was produced, show the formula bar and the period assumption. Point them to how to calculate a raise for the same identity in prose. If the debate is really about budget size rather than arithmetic, switch to how raise budgets are set instead of re-litigating cell D2.

Accessibility and localization tips

Keep formula columns to the right of inputs so screen-reader users encounter values before results. Avoid merging cells across the input block. For locales that use commas as decimals, set workbook locale explicitly or normalize imports before calculating. Document the locale in the Inputs sheet header.

Versioning merit cycles

Save a dated copy of the grid when budgets lock (merit-2026-final.xlsx). Do not overwrite the locked file with late adjustments; append an adjustments sheet with effective dates so back-pay math can reconstruct who was owed what. That habit feeds cleanly into retro pay workflows later.

What this post intentionally skips

Tax withholding elections, equity refreshes, and shift differentials need payroll-specific systems. This article stays on base-pay percent math in Excel and Sheets so it remains accurate without pretending to be a full total-rewards engine.