Friday, June 15, 2012

Quick Percentage Change Calculation

A colleague taught me a trick to calculate percentage change quicker than the traditional way at the start of my last job. Below is the formula, it basically just cancels out steps that I’d done before, but for some reason I’d never thought to do it this way.

(Ending value/Beginning Value)-1

Example, last quarter I sold 100 units and this quarter I only sold 75, thus I had a decrease of 25, I can calculate the percentage change really quick.

(75/100)-1 = -.25 or a 25% drop.

This little trick works, and if you use it, you can save a lot of time in the long run.

For more math and Excel tips visit: