Assume 2020 Q1 is in cell B1 and 2019 Q1 sales is in A1. Percentage difference formula is
Formula:
=(B1-A1)/A1
Set the format for the cell to be "%".
Assume 2020 Q1 is in cell B1 and 2019 Q1 sales is in A1. Percentage difference formula is
Formula:
=(B1-A1)/A1
Set the format for the cell to be "%".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks