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

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

knifey_spoonie · 2004-06-15 08:38:41

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…

Options

15-06-2004 9:38am

#1

knifey_spoonie

Registered Users Posts: 3,648 ✭✭✭

Join Date: February 2004

Posts: 3510

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

0

Comments

Options
#2 15-06-2004 9:50am
Mr E

Registered Users Posts: 55,519 ✭✭✭✭

Join Date: November 2001

Posts: 47736

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.

0
Options
#3 15-06-2004 9:51am
thegills

Registered Users Posts: 1,802 ✭✭✭

Join Date: December 2001

Posts: 1640

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

0