I am looking to calculate in one cell how much of a budget in the month of May is spent inefficiently because the actual prices we are paying are greater than the target price.
The formula I'm looking to create will take the following steps.
1. Identify if actual prices in one column throughout the month are greater than the target price
2. If the actual price is greater, I want to find the difference between the target price and the actual price
3. Then I want to take the difference in the prices and multiple it by the # of units bought at that price
4. Sum the amount spent
4. Divide the sum by total budget spent
Thank you!
Bookmarks