Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

A simple excel function , but I just cant do it!

  • 15-06-2004 8:38am
    #1
    knifey_spoonie
    Registered Users, Registered Users 2 Posts: 3,648 ✭✭✭


    What I want to do is really simple , I just want to add the value in a single cell to every cell in a colum. Specificily the value in a139 to every cell between b3 and b137.
    I cant find the function to do it in excel , even though Im sure its there and I cant find a link to it even though Im very sure that its there. Any help is greatly appreciated
    cheers


Comments

  • #2
    Mr E
    Registered Users, Registered Users 2 Posts: 55,572 ✭✭✭✭Mr E


    Select cell C3.
    Use the formula: =$A$139+B3
    Highlight column C from C3 to C137.
    Press Ctrl+D (Fill Down).
    This will add A139 to all the values in column B and put the results in column C.


  • #3
    thegills
    Registered Users, Registered Users 2 Posts: 1,802 ✭✭✭thegills


    You need to use an array formula.

    1. Highlight C3 to C137
    2. Type = A139 + B3:B137
    3. Press CTRL+SHIFT+ENTER

    You get the result you need in C3 to C137. i.e. C20 = B20 + A139.

    thegills


Advertisement