# Percent Change Calculation in Excel

Learn how to build an Excel percent change formula for tire sizing: enter the sidewall numbers, use cell references, format as a percentage, and read increase or decrease.

A percent change calculation in Excel shows how far one tire dimension sits from another as a share of the original value. You subtract the old figure from the new one, divide the result by the old figure, and format the cell as a percentage. Tire technicians use it to compare a sidewall size against a nominal figure and to read the difference as an increase or a decrease. 

## Building the percent change formula 

An Excel percent change formula follows one structure: new value minus old value, divided by old value. Type it as = (B2 - A2) / A2, with the first tire dimension in column A and the second in column B. The parentheses matter because they force Excel to subtract before it divides. Without them, the formula divides separately and returns a wrong figure. 

## Using cell references correctly 

Cell references let one formula serve a whole column of tire comparisons. Place the original dimension in one cell and the changed dimension in the next cell, then fill the formula down the rows. Relative references shift with each row, so every pair of rows is calculated with its own values. Absolute references, marked with dollar signs, hold a cell fixed when you copy a single reference down. 

## Reading increase and decrease 

A positive result means the second tire dimension is larger than the first, an increase. A negative result means the measurement has dropped, a decrease, and Excel shows it with a minus sign. Convert the decimal to a percentage through the percentage format on the ribbon. Formatting changes only how the number is displayed, so the underlying value stays ready for further sums. 

## Questions About Excel Percent Change 

### How do I do a percent change calculation in Excel? 

Excel performs a percent change calculation when you subtract the old value from the new value and divide by the old value. Enter the formula with the two cells holding the tire dimensions, for example = (B2 - A2) / A2. Press Enter and the cell shows a decimal that you can format as a percentage. A result of zero means the two dimensions match. 

### Why does my Excel percent change formula show a decimal instead of a percentage? 

Excel stores a percent change formula result as a decimal number by default. The percentage format converts that decimal into a readable share, so 0.05 appears as five percent. Select the cell and choose the percentage format on the ribbon or the number format menu. This changes only the display and leaves the number unchanged. 

### How do cell references change the result of the formula? 

Cell references determine which tire dimensions the formula looks at when it calculates. A relative reference such as A2 moves to A3 when you copy the formula down, so each row keeps its own pair of values. An absolute reference such as $A$2 stays on the same cell whenever you copy it. Choosing the wrong reference type gives a result that does not match the row. 

### How do increase and decrease show up in an Excel percent change result? 

Excel shows an increase as a positive percent change and a decrease as a negative one. The sign tells you which direction the second tire dimension moved relative to the first. A decrease appears with a minus sign in the cell after percentage formatting. Keep the sign visible when you compare dimensions so the direction stays clear.
