+ Reply to Thread
Results 1 to 3 of 3

Copying a basic formula to multiple cells in a column, while keeping the source cell

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Eston, South Africa
    MS-Off Ver
    Office 2007
    Posts
    2

    Copying a basic formula to multiple cells in a column, while keeping the source cell

    Hi folks

    I am busy doing a price list for a product we import. I need to multiply each price by a number contained in a cell to work out my landed cost.


    To elaborate:

    I have a value in Cell D8 that is my multiplier for customs and Tax. Each price on the price list needs to refer to this cell to give me a total in the corresponding cell in column G.

    IE: =F13*D8, =F14*D8, =F15*D8 etc

    When I try copy the first one (=F13*D8) to the cells in G column, it keeps changing the D8.

    IE: =F13*D8, =F14*D9, =F15*D10

    How do I copy / paste so that it keeps the reference to D8, but changes the F numbers?

    I hope I have been clear enough in my explanation!

    Thanks for the time

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,195

    Re: Copying a basic formula to multiple cells in a column, while keeping the source cell

    It seems like you need a basic absolute reference -- one of those first things to learn about spreadsheet programming. "$" before the column letter and or row number makes that part of the reference absolute, and a "$" before both column letter and row number makes both absolute. So use something like =F13*$D$8. I'd recommend that you spend some time with something like this to review the behavior of different types of references: https://support.office.com/en-us/art...e-5f0d8d0baca9
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Eston, South Africa
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Copying a basic formula to multiple cells in a column, while keeping the source cell

    MrShorty, thank you sir!!

    Works perfectly
    Last edited by MartinKZN; 01-11-2019 at 11:06 AM.

+ 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