+ Reply to Thread
Results 1 to 4 of 4

Multiplying in a row

Hybrid View

  1. #1
    Daniel - Sydney
    Guest

    Multiplying in a row

    Hi

    I need to multiply a row of numbers by 30%,
    the row extends from A4 to W4.

    How do I do it.

    thanks

    Daniel

  2. #2
    tjtjjtjt
    Guest

    RE: Multiplying in a row

    You want A4:W4 to be 130% of their curretn values?
    Type 1.3 in a cell.
    Then, copy that cell.
    Select A4:W4.
    Go to Edit | Paste Special. Choose Multiply and click Okay.


    --
    tj


    "Daniel - Sydney" wrote:

    > Hi
    >
    > I need to multiply a row of numbers by 30%,
    > the row extends from A4 to W4.
    >
    > How do I do it.
    >
    > thanks
    >
    > Daniel


  3. #3
    Daniel - Sydney
    Guest

    RE: Multiplying in a row

    Thanks for your help

    Daniel

    "tjtjjtjt" wrote:

    > You want A4:W4 to be 130% of their curretn values?
    > Type 1.3 in a cell.
    > Then, copy that cell.
    > Select A4:W4.
    > Go to Edit | Paste Special. Choose Multiply and click Okay.
    >
    >
    > --
    > tj
    >
    >
    > "Daniel - Sydney" wrote:
    >
    > > Hi
    > >
    > > I need to multiply a row of numbers by 30%,
    > > the row extends from A4 to W4.
    > >
    > > How do I do it.
    > >
    > > thanks
    > >
    > > Daniel


  4. #4
    Gord Dibben
    Guest

    Re: Multiplying in a row

    Enter .3 in an unused cell.

    Select and copy.

    Select A4:W4 and Paste Special>Multiply>Ok>Esc.


    Gord Dibben Excel MVP

    On Mon, 26 Sep 2005 16:05:02 -0700, Daniel - Sydney <Daniel -
    Sydney@discussions.microsoft.com> wrote:

    >Hi
    >
    >I need to multiply a row of numbers by 30%,
    >the row extends from A4 to W4.
    >
    >How do I do it.
    >
    >thanks
    >
    >Daniel



+ 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