Question

How can I calculate percentage differences between multiple percentage values in google sheets?

I need help to know how I can do this the best/correct way :)

So my case is:
I have a spreadsheet my collegues filled in with different prices from different locations and my task is to count the difference between highest and lowest (minus the top and lowest 5-10% since they variate to much) and see the percentage difference and then there are multiple columns that I in the end need to count out the difference from all together to get a final difference in percentage :)

Example:
Column A
says from top to bottom:
2800
3000
3500
4900

Column B says:
2100
2900
5000
7000
9000

column C... etc

And then all the columns % diff should be counted the difference also :P

sheets.jpg

Mentioned
#Google Sheets
Share
bigal123's avatar
24d

What do you mean the percentage difference? In your example in column A, the lowest amount is 2800 and the highest amount is 4900. Difference is 2100. Is the percentage difference -25% (2100/2800-1) and -57% (2100/4900-1)?

1 point
What's the best to-do list app in 2021?

When you've got too many things to do, how do you keep track of them all? Have you started using a new to-do list app recently, or found an old one is still doing the job well? The last time we di...

The community for Google Sheets  power users.