Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

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 ...