Query in Excel Closed

Question

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

TrowaD · Answer

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

Query in Excel

1 response

Similar discussions

Subscribe To Our Newsletter!