Re: Subtracting cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: triad (triad33_at_earthlink.net)
Date: 03/21/04


Date: Sat, 20 Mar 2004 20:40:30 -0600

Thanks both very much, it was the CTRL that I was missing. I have a MS
Office book and I could not find it in there I guess it probably is as it is
probably a basic function. Thanks again
"triad" <triad33@earthlink.net> wrote in message
news:105psbj459bbm25@corp.supernews.com...
> I have imported a stock price list into Excel 2000. Line 1 has: date /
open
> / close / high / low, in cells A thru E . I have 72 lines of this and I
> want to subtract E from D in all lines. I can do individual lines with the
=
> D2-E2 and it gives the answer where I previously put the cursor preferably
> F. But I can't get all to subtract at once. I can highlight the whole
D2:D72
> and E2:E72 and highlight all of cell F but it will still only subtract 1
> line . Thanks
>
>



Relevant Pages

  • Re: OT: Math Problem
    ... Subtract a**2 from both sides of the equation, ... the professor frowns, leaves the class for 10 minutes... ...
    (comp.lang.cobol)
  • Re: column count
    ... Maybe I'm missing something, but if you already have the column numbers, why ... can't you just subtract one from the other to get number of columns? ... (email address is on the web site) ... of letters? ...
    (microsoft.public.excel.programming)
  • RE: Word count issue
    ... symbols like that and subtract it from the total. ... You can use the Ctrl + F command to find the symbols and numbers that you ... dont want. ...
    (microsoft.public.word.newusers)
  • Re: Complicated update
    ... Then just add the missing) in: ... since you cannot subtract 10000 from the string Mileage. ... If I explain, this previous total mileage =9500, this travel= 600. ...
    (microsoft.public.access.queries)
  • Re: MISSING NUMBER
    ... Mensanator wrote: ... One number is missing, how to find ... Adding the number then subtract N/2 may not be possible ... Use a math library where "too big to store" isn't an issue. ...
    (comp.programming)