Query in Excel

Closed
Lax - Oct 6, 2010 at 09:26 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Oct 7, 2010 at 10:38 AM
Hi
I have two worksheets Pg 1 and Pg 2

Pg 1 has the following Data for 2nd Oct

Company Name Volume Traded
A 600
B 400
D 525
E 323
G 112

Pg 2 has the following Data for 3rd Oct

Company Name Volume Traded Percentage increase in Volume
A 2000 ?
B 150 ?
C 650 ?
D 400 ?

Now In Pg 2 i need to Calculate the percentage increase or decrease in volume as compared to 2nd Oct

Can Anyone pls help me as to how I can do it using Excel 2003

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Oct 7, 2010 at 10:38 AM
Hi Lax,

You mean like this?:

=(A1-Sheet1!A1)/Sheet1!A1*100

The increase between 600 and 2000 is 1400.
And 1400 is 233,33% of 600.

Best regards,
Trowa
0