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
12 months ago

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)?

2 points
Gkbubbles90's avatar
@Gkbubbles90 (replying to @bigal123 )
9 months ago

It was solved, thank you for reply :)

1 point
The community for Google Sheets  power users.