Quick answer
With initial in column A and final in column B, change = B2 - A2.
Formula
- =B2-A2
- Fill down for each row
Introduction
The Absolute Change Calculator on our home page applies final minus initial as you type. Use it to verify a single row after you build a sheet.
Tables with initial year, final year, and change columns are standard in corporate models and class assignments.
Read how to calculate absolute change for the pencil workflow before you scale to hundreds of rows.
Google Sheets uses the same syntax as Excel for this task. The examples below use Excel labels, but you can copy them directly.
Column layout
Row 1 headers: Initial, Final, Absolute change. One pair per row keeps fill-down honest.
Format source columns as currency or number. Format the change column as number unless you mistakenly build a ratio.
Avoid mixing blank rows inside the data block. Blanks can make fill-down stop early or skip rows silently if formulas are not consistent.
Core formulas
- =B2-A2
- =IF(ISNUMBER(B2),B2-A2,"")
- Fill handle: double-click or drag
Final must live in the column you subtract from. Swapping columns flips every sign in the table.
ABS(B2-A2) answers a different question (size only). Use ABS only when the assignment asks for magnitude without direction. If the subtraction order confuses you, revisit the absolute change formula before editing the sheet.
Spreadsheet steps
- Type initial and final. Columns A and B in the examples.
- Enter =B2-A2 in C2. Press Enter.
- Fill down. Copy for all rows.
- Spot-check row 2. Match the home calculator.
- Sort carefully. Sort the whole table, not the change column alone.
Small table
Row 2: 40 to 55 gives 15. Row 3: 100 to 92 gives -8. Both match hand subtraction.
If row 4 initial is blank, use IF wrappers so you do not show -final by accident. Clean data entry beats clever formulas.