How to Calculate the Decline in Sales by Percent for the Number of Years in Excel. When calculating a declining sales figure spanning multiple years, you need to calculate two percentages.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...