Query in Excel

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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