+ Reply to Thread
Results 1 to 4 of 4

multiplying columns

  1. #1
    Horizon Dude
    Guest

    multiplying columns

    I want stuff in column A multiplied by stuff in column B and end up in column
    C. I would like to have this done automatically instead of doing it every
    time i update my sheet. Any help would be greatly appreciated


  2. #2
    Harald Staff
    Guest

    Re: multiplying columns

    You will need a computer with a keyboard, a mouse and a spreadsheet program
    installed on it. Write this in cell C1 of a spreadsheet file's worksheet:

    =A1*B1

    and press the Enter key.
    Click on cell C1 again. The lower right corner of the cell will be a small
    black square. Put the mouse pointer onto it, hold down the left mousebutton
    (or the mousebutton if you have only one) and, while holding, drag the mouse
    towards the side of the table where your body is. After two or maybe three
    minutes, remove your hand from the mouse. Save the file.

    Enter stuff in A and B of this sheet in this file from now on and enjoy the
    miracles of modern number crunching.

    HTH. Best wishes Harald

    "Horizon Dude" <HorizonDude@discussions.microsoft.com> skrev i melding
    news:A54F75AA-5DED-43C3-91C0-3B44AA5745AA@microsoft.com...
    > I want stuff in column A multiplied by stuff in column B and end up in

    column
    > C. I would like to have this done automatically instead of doing it every
    > time i update my sheet. Any help would be greatly appreciated
    >




  3. #3
    David Billigmeier
    Guest

    RE: multiplying columns

    In C1:

    =A1*B1

    and drag down to the end of your data.

    --
    Regards,
    Dave


    "Horizon Dude" wrote:

    > I want stuff in column A multiplied by stuff in column B and end up in column
    > C. I would like to have this done automatically instead of doing it every
    > time i update my sheet. Any help would be greatly appreciated
    >


  4. #4
    Tom Ogilvy
    Guest

    Re: multiplying columns

    select column C, with C1 as the activeCell

    go to the formula bar and enter

    =A1*B1

    then hit Ctrl+enter instead of just enter.

    --
    Regards,
    Tom Ogilvy

    "Horizon Dude" <HorizonDude@discussions.microsoft.com> wrote in message
    news:A54F75AA-5DED-43C3-91C0-3B44AA5745AA@microsoft.com...
    > I want stuff in column A multiplied by stuff in column B and end up in

    column
    > C. I would like to have this done automatically instead of doing it every
    > time i update my sheet. Any help would be greatly appreciated
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1