+ Reply to Thread
Results 1 to 3 of 3

Adding to an entire column?

  1. #1
    Registered User
    Join Date
    10-31-2007
    Posts
    2

    Adding to an entire column?

    Hey all,

    I tried to browse this forum (and google) for the answer to this question but I can't find it.

    I haven't really used Excel since highschool. I understand it easy enough, just have forgotten most of how to do things.

    On to my problem, I have a sheet for a class I'm a graduate assistant for. Column A contains names, Column B contains Mid-term grades.

    The teacher is going to curve the grades. Thus, I want to make a Column C, with 14 added to each value from B, and displayed in the corresponding cell in C.

    Ex, B2 = 65 C2 = 79
    B3 = 56 C3 = 70

    Is there any quick way I can apply a formula that adds 14 to each individual cell from B and puts it into the individual cells in C?

    I'm sorry if this is extremely easy/stupid, I just can't figure it out or find how online and I'd rather not manually add 14 to over 100 cells. That is what excel is here for right? Making things easier.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    =B2+14
    and drag down

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    10-31-2007
    Posts
    2
    Thanks a ton! I knew it had to be something ridiculously easy. That saves me some more time to focus on my own work that really needs my attention!

    Again, 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