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.