+ Reply to Thread
Results 1 to 8 of 8

Increasing by set amount

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    Bangkok Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Red face Increasing by set amount

    Hello, I tried searching for over 2 hours before I posted. I think this is an easy one and maybe I was searching the wrong words. What I would like to do is increase some numbers across a row. In E4 I have the value .045 which is the starting value. In E5 I have the value .005 which is the amount I want to increase by incrementally. In B8 I type =E4. I want to increase from B8 to C8 by .005 and then increase C8 by .005 etc.....so that going across from B8 to C8 to D8 to E8 to F8...etc the values would increase by .005 each time. What formula should I use to do this? I know if I typed manually it would look like C8=B8+.005 and D8=C8+.005 and E8=D8+.005 etc..but I have a lot to do and this is very cumbersome.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Increasing by set amount

    In C8:

    =B8 + (C8 * COLUMN(A1))


    ...and copy across.


    Or even:

    =B8 + $E$5

    ...and copy across.
    _________________
    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 2007,2010,365
    Posts
    44,086

    Re: Increasing by set amount

    E4: 0.045
    E5: 0.005

    B8: =E4
    C8: =B8+$E$5 and drag across

    Regards

  4. #4
    Registered User
    Join Date
    09-22-2010
    Location
    Bangkok Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Increasing by set amount

    I tried =B8 + $E$5...and copy across, but it does not seem to want to copy across. I have tried it two ways: (1) I click in C8 and use the big white cross and then drag it across and press enter,but nothing happens. (2) I click in C8 and use the small black cross, click and hold and then drag across, but all it does is put the same value (0.05) in all the cells and I of course want the values to increase by .005 each time, (i.e. .045,.050, .055, .060, etc..)

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Increasing by set amount

    Have you got calculation turned off in this workbook?

    Regards

  6. #6
    Registered User
    Join Date
    09-22-2010
    Location
    Bangkok Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Increasing by set amount

    "Have you got calculation turned off in this workbook?" How would I check this?

  7. #7
    Registered User
    Join Date
    09-22-2010
    Location
    Bangkok Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Increasing by set amount

    "Have you got calculation turned off in this workbook?" How would I check this? Never mind, you were right, I went to Excel options.. Formulas...Calculation options....and it was on Manual. I changed to Automatic and it works now. Thanks much

  8. #8
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Increasing by set amount

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ 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