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…

15-06-2004 08:38AM

#1

knifey_spoonie

Registered Users, Registered Users 2 Posts: 3,643 ✭✭✭

Join Date: February 2004

Posts: 3505

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

#2 15-06-2004 08:50AM

Mr E

Registered Users, Registered Users 2 Posts: 55,751 ✭✭✭✭

Join Date: November 2001

Posts: 47956

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
#3 15-06-2004 08:51AM

thegills

Registered Users, Registered Users 2 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