Finding percentage Difference

[DMT Dave]

Hi Guy's hope you are all well



I know this is an Excel question on this Access forum that are full of genius's

still i know you can make this one simple

I am trying to calculate the percentage difference and loosing my self a little on the formula in excel

i have tried several google calculations but can't appear to get the correct logical answer!!!

So i have 2 figures

19500 cell B9

and 32270 Cell I11

so i am trying to find the difference in percentage

The method i have tried from google is =B9/$I$11

this is returning 60.43%

If i am barking up the wrong tree please nudge me, i would have thought logically that this should be around mid 30's % difference ?

If this calculation is correct then please forgive me

[Welshgasman]

I am unsure by what you mean 'difference in percentage'?
As you have it now 19500 is 60.43% of 32270?, so if you wanted to know the % of income from cell B9 over the total in I11, then that would be correct?

[xps35]

Maybe = (I11-B9) /B9?

[isladogs]

I think that should be =(I11-B9)/I11 or 1- (B9/I11)

[DMT Dave]

Hi Guy's Colin's method worked, the result returns

=(I11-B9)/I11 = 39.7%

So that is correct in which logic told me 60 + percent was too much of a difference

Thank you guy's

[Welshgasman]

Hi Guy's Colin's method worked, the result returns

=(I11-B9)/I11 = 39.7%

So that is correct in which logic told me 60 + percent was too much of a difference

Thank you guy's

So you just adjusted the formula to get the value you think it should be?

[isladogs]

Dave
You were just calculating a ratio as a %...not the difference.
Anyway, I make it 39.57%

[Welshgasman]

Dave
You were just calculating a ratio as a %...not the difference.
Anyway, I make it 39.57%

It would be the remainder of the 100% from the first calc, would it not?

[DMT Dave]

Hi WGM, you are no doubt right, for some reason, percentages i can struggle with a simple equation

with no arriving on a banana boat i know 33/100 is 33% or 1/3 in fractions, i can just never seem to get the correct formula on paper

when i had asked 19500 and 32270, i was coming up with 60 + percent, i knew the percentage was under 50 and perhaps in the 30's because 2 x 19500 is 39000 and having 32270 as a number, it had be less than 50% percent increase but just couldn't get any return under 60% and knew it was my calc method

Colin's method simply solved it

much appreciated you response though

just read colin's reply and seen a slight difference so it's clarifying the formula, having tried a few online ones i was getting 60 + percent which made me assume it was wrong.

[DMT Dave]

Hi Colin, just used your suggestion as in post 6, is that still correct because using =(I11/B9)/I11 which is >> = larger value - smaller value divide the larger value ?

i get 39.7% with the excel cell formatted as percent whereas you get 39.57 ? is this the cell format creating a difference albeit small difference but i would like to know if i am wrong ?

appreciated

[isladogs]

The formula in post #10 isn't what I wrote in post #4.

Think about it. You originally got 60.43%
100-60.43 = 39.57%

[DMT Dave]

Hi Colin, yes i have now got the same value using

= 1- (B9/I11)

as per your suggestion

Thanks again