Average of percentages
desiree3007
Posted messages
2
Status
Member
-
desiree3007 Posted messages 2 Status Member -
desiree3007 Posted messages 2 Status Member -
Hello,
I am working on an Excel spreadsheet with the prices from a supplier, to which I have compared the prices of the same products from other suppliers. For each one, I have calculated the percentage difference from my reference price.
I would like to calculate the average of the percentage differences from my starting price: the desired result would be to know that overall, a certain supplier is xx% more expensive or cheaper than my current supplier.
What is the most suitable formula? Thank you in advance for your help!
Désirée
I am working on an Excel spreadsheet with the prices from a supplier, to which I have compared the prices of the same products from other suppliers. For each one, I have calculated the percentage difference from my reference price.
I would like to calculate the average of the percentage differences from my starting price: the desired result would be to know that overall, a certain supplier is xx% more expensive or cheaper than my current supplier.
What is the most suitable formula? Thank you in advance for your help!
Désirée
1 answer
-
Hello
without seeing the workbook and without a crystal ball...
Attach the workbook without confidential data on https://www.cjoint.com/
and paste the shortcut by right-clicking on the link provided in the reply message
Looking forward
--
Michel-
Here it is :) https://www.cjoint.com/c/FCrj4I7HNcf Thank you!
-