+ Reply to Thread
Results 1 to 7 of 7

Formula with relative reference

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Formula with relative reference

    hello im new in the forums, i have a question about an exel formula, this is one of those questions i keep reading and i still don't understand

    10. In cell B18, enter a formula to calculate the amount of money loaned to Ghana in 2013 that SWM can expect will be repaid. In the formula, use a relative reference to the loan amount in cell B12 and an absolute reference to the “Repayment rate to date” value in cell K1. Copy the formula in cell B18 to the range C18:M18
    excel.PNG

    in advance thanks you for your help looking forward to contribute to the forums

    MigLMunoz

  2. #2
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    33,062

    Re: Formula with relative reference

    You use $ signs to make parts of cell addresses "fixed" or "absolute". Without them, they are already relative (they change as you copy the formula from cell to cell).


    A1 = relative column, relative row
    $A1 = absolute column, relative row
    A$1 = relative column, absolute row
    $A$1 = absolute column, absolute row
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,852

    Re: Formula with relative reference

    I guess you'd multiply the amount in B12 (with a relative reference) with the value in K1 (with an absolute reference). K1 is assumed to be a percentage.

    But really you should be asking your tutor to explain it to you, not getting the answers from a forum and pretending it's all your own work.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    03-14-2013
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula with relative reference

    Thank you for the help and i wish i had a tutor but my class in online using SAM 2010 and my tutor wld take hours to answer if not longer, i wasnt just looking for and answer or a formula but also for an explanation to the formula.

  5. #5
    Registered User
    Join Date
    03-14-2013
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula with relative reference

    thanks! i think this is pointing me to the right direction

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,852

    Re: Formula with relative reference

    You're welcome. Thanks for the rep.

    I'm pleased that you are moving in the right direction. We try to avoid just giving answers to homework questions and assignments as you need to understand not just that you have an answer but where that answer came from.

    Looks like you've filled in most of the workbook so it would seem you are making progress.

    Regards, TMS

  7. #7
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    33,062

    Re: Formula with relative reference

    Thanks for the feedback.

    If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

+ 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