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

Column A
says from top to bottom:

Column B says:

column C... etc

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


#Google Sheets
bigal123's avatar
a year 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 )
a year ago

It was solved, thank you for reply :)

1 point
What's the best video conferencing app for internal discussions?

Three major considerations I have been using to evaluate the plethora of options available: 1. Effortless/non-intrusive: It shouldn't feel like a video call 2. Price: As this app would be complime...

Confluence alternatives for wiki/knowledge bases?

I've been looking to try something new for knowledge/documentation storage for a little while now. Confluence has always been there, but I find it to be relativly limited for the cost and additiona...

How do you manage your chat inbox?

Hey guys, first post here. As part of my work, I have to deal with and respond to a lot of incoming messages from different chats: Linkedin/WhatsApp/Signal/IG. I try to use Unreads/Archive features...

The community for Google Sheets  power users.