HI,
not neccesarily an Excel issue specifically, but i'm trying to work out the impact a change in sales has on a ratio.
the table below shows a loose illustration comparing the year on year movement of Cost vs Sales. I want to show how the impact of price movements for each line contributes to the total.
As the variable in this instance is a denominator, its not a simple to calculate. (Cost of goods is easier, as you can do (change in cost) / sales to work out the impact)
Any help would be marvelous, as i've trawled the internet with no solution.
Bookmarks