Figuring percentage difference

In cell H6 I have 300,000 In cell G14 I have 206,813

I 开发者_如何转开发can't figure out how to write a formula in Excel to calculate the percentage difference. I keep coming up with like 45%.

You probably did (H6 / G14) * 100 while you should do G14 / (H6 / 100) or (G14 / H6) * 100, what ever notation you like :)

Are you looking for difference percentage as outlined by this Wikipedia article?

Then do

=ABS((H6-G14)*2/(H6+G14))

If you want it shown as a percentage, multiply by 100 (or even better, set the cell to a percentage).