Calculating how far a number has declined from one year to the next is pretty easy if you are only considering a one year period. You subtract the current year's number from last year's number, then ...

Excel percentage formulas can get you through problems large and small every day—from determining sales tax (and tips) to calculating increases and decreases. We’ll walk through several examples below ...

Calculate annual % change by dividing start by end value, raising to inverse years, minus one, times 100. Ex: a drop from $15M to $10M over 2 years is a 18.4% average annual decline. This calculation ...