Percentages

  • Thread starter Thread starter triad
  • Start date Start date
T

triad

I am trying to get some percentages from a sheet that I have imported with
about 300 stock prices. I want to get what percent D 1-300 is of C 1-300 and
have the answer go to H. I checked the help file and can't seem to find
this. Thanks
 
Triad, in Cell H1: =D1/C1 and press enter. Format the cell as %. Copy the
formula down Column H.

Or if you mean whole columns, then =SUM(D1:D300)/Sum(C1:C300).
 
Thanks DDM!
DDM said:
Triad, in Cell H1: =D1/C1 and press enter. Format the cell as %. Copy the
formula down Column H.

Or if you mean whole columns, then =SUM(D1:D300)/Sum(C1:C300).
Click to expand...
 
Back
Top