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?

87.9	-549	-376	-378	-56.5	-50	109.5	132.1	248.3	270.3
87.5	-574	-399	-399	-71	-71	119.2	119.2	259.1	259.1

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

	Load	BM	1	2	3	4	5	6	7	8	9
Actual	502.4	87.9	-549	-376	-378	-56.5	-50	109.5	132.1	248.3	270.3
Theoretical	500	87.5	-574	-399	-399	-71	-71	119.2	119.2	259.1	259.1
	% Change	0.46%	4.59%	5.98%	5.50%	25.66%	42.00%	-8.86%	9.77%	-4.35%	4.14%

 

[George182]

No worries.

 

[Deeg]

=A1/B1-1