Excel help

[conneh]

I'm trying to work out the % difference between 2 sets of numbers, however everything i find online / seem to do myself just doesn't look right to me.

What formula should i be using for this?

[TABLE="width: 464"]
[TR]
[TD="align: right"]87.9[/TD]
[TD="align: right"]-549[/TD]
[TD="align: right"]-376[/TD]
[TD="align: right"]-378[/TD]
[TD="align: right"]-56.5[/TD]
[TD="align: right"]-50[/TD]
[TD="align: right"]109.5[/TD]
[TD="align: right"]132.1[/TD]
[TD="align: right"]248.3[/TD]
[TD="align: right"]270.3[/TD]
[/TR]
[TR]
[TD="align: right"]87.5[/TD]
[TD="align: right"]-574[/TD]
[TD="align: right"]-399[/TD]
[TD="align: right"]-399[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]119.2[/TD]
[TD="align: right"]119.2[/TD]
[TD="align: right"]259.1[/TD]
[TD="align: right"]259.1[/TD]
[/TR]
[/TABLE]

Basically just want to show the percentage difference between the top and bottom number. I have been using 87.9 - 87.5 / 87.9... but it just doesnt seem to be working for me.

Thanks

 

[sbridgey]

Do this

(87.9 - 87.5) / 87.9

 

[George182]

(87.9 - 87.5)/87.9

x100

hey presto

0.46%

 

[conneh]

Hmm looks what what i did do was correct! Thanks

[TABLE="width: 592"]
[TR]
[TD][/TD]
[TD]Load[/TD]
[TD]BM[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Actual[/TD]
[TD="align: right"]502.4[/TD]
[TD="align: right"]87.9[/TD]
[TD="align: right"]-549[/TD]
[TD="align: right"]-376[/TD]
[TD="align: right"]-378[/TD]
[TD="align: right"]-56.5[/TD]
[TD="align: right"]-50[/TD]
[TD="align: right"]109.5[/TD]
[TD="align: right"]132.1[/TD]
[TD="align: right"]248.3[/TD]
[TD="align: right"]270.3[/TD]
[/TR]
[TR]
[TD]Theoretical[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]87.5[/TD]
[TD="align: right"]-574[/TD]
[TD="align: right"]-399[/TD]
[TD="align: right"]-399[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]-71[/TD]
[TD="align: right"]119.2[/TD]
[TD="align: right"]119.2[/TD]
[TD="align: right"]259.1[/TD]
[TD="align: right"]259.1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]% Change[/TD]
[TD="align: right"]0.46%[/TD]
[TD="align: right"]4.59%[/TD]
[TD="align: right"]5.98%[/TD]
[TD="align: right"]5.50%[/TD]
[TD="align: right"]25.66%[/TD]
[TD="align: right"]42.00%[/TD]
[TD="align: right"]-8.86%[/TD]
[TD="align: right"]9.77%[/TD]
[TD="align: right"]-4.35%[/TD]
[TD="align: right"]4.14%[/TD]
[/TR]
[/TABLE]

 

[George182]

No worries.

 

[Deeg]

=A1/B1-1