Re: Percentages

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: DDM (DDMara_at_YaNOSPAMhoo.com)
Date: 05/02/04

  • Next message: Frank Kabel: "Re: Formatting Cells to display Date: month/day/year" 
    Date: Sun, 2 May 2004 15:31:45 -0400

    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). 

    -- 
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
"triad" <triad33@earthlink.net> wrote in message
news:109ahnp7572r35d@corp.supernews.com...
> I am trying to get some percentages from a ***  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
>
>
  • Next message: Frank Kabel: "Re: Formatting Cells to display Date: month/day/year"
    • Quantcast