+ Reply to Thread
Results 1 to 4 of 4

I want to be able to copy/paste a formula

  1. #1
    Registered User
    Join Date
    09-23-2009
    Location
    Redlands, CA
    MS-Off Ver
    Excel 2003
    Posts
    17

    I want to be able to copy/paste a formula

    Lets say I have values in A1, B1, and A25. I have a formula in C1 as follows:
    =(A1*B1)/A25

    How can I write this formula differently so that if I were to select C1 cell, copy, then paste it into C2 it will read as follows:
    =(A2*B2)/A25



    Any help would be greatly appreciated. Thx.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: I want to be able to copy/paste a formula

    Use $:

    =(A1*B1)/$A$25

  3. #3
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    356

    Re: I want to be able to copy/paste a formula

    nscherneck

    Think of the $ as a place holder in a formula. If is only before the column ($A25), then the column reference will not change when the formula is copied. If is only before the row (A$25), then the row reference will not change when the formula is copied. If it is before both ($A$1) the neither row or column reference will change when copying the formula.

    Relative reference A25
    Mixed reference $A25 or A$25
    Absolute reference $A$25
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: I want to be able to copy/paste a formula

    For more about cell referenceing see here:

    http://www.youtube.com/watch?v=NmVMjQzseLA

+ 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