+ Reply to Thread
Results 1 to 2 of 2

Increment cell reference

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Increment cell reference

    Hi I want to do some multiplication using quarterly weights with annual data,

    YEAR / Quarterly Weight / Year / Annual Figure
    1960Q1, 0.243062075, 1960 , 51.81711062
    1960Q2, 0.243510145 , 1961 , 57.96708711
    1960Q3, 0.251873542 , 1962 , 62.98765423
    1960Q4, 0.261554238 , 1963 , 68.48925534
    1961Q1, 0.24091194,
    1961Q2, 0.246046693,
    1961Q3, 0.250768104,
    1961Q4, 0.262273263,


    To illustrate:
    For 1960Q1, I want to get 0.243062075*51.81711062
    For 1960Q2, I want to get 0.243510145*51.81711062
    For 1960Q3, I want to get 0.251873542*51.81711062 ...

    Can someone tell me how to do this in excel? Any help will be appreciated!!

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Increment cell reference

    George.ca, Good evening.

    I did an example for you.
    22-03-2014_ExcelForum_Incremente_cell_OK.xls

    Is it what you want?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Increment cell reference

    Yes, that's exactly what I want!

    Thanks a lot, Marcílio!

    Best wishes,
    George

    Quote Originally Posted by Mazzaropi View Post
    George.ca, Good evening.

    I did an example for you.
    Attachment 306277

    Is it what you want?
    I hope it helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to increment an absolute cell reference
    By acharletta in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-06-2013, 08:03 PM
  2. [SOLVED] Increment Cell Reference
    By XLVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2012, 08:33 AM
  3. Inserting a row does not increment reference in cell
    By diguerd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2008, 01:26 PM
  4. Increment Cell Reference
    By Perry in forum Excel General
    Replies: 4
    Last Post: 03-08-2006, 04:20 AM
  5. A2 cell reference increment
    By cejones in forum Excel General
    Replies: 3
    Last Post: 11-07-2005, 11:45 PM

Tags for this Thread

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