Excel Study · Module 1: First steps
Class 9Percentage change
Basics1:53 videoFree
Did sales grow or shrink, and by how much? Percentage change is new minus old, divided by old: =(C2-B2)/B2 — with brackets, so the subtraction happens first.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, last year's sales are in B2 and this year's sales are in C2. Write a formula for the percentage change.
The answer that works
✓ checked in Excel=(C2-B2)/B2
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.