Adding a constant to a formula. Problems w/filling in
 

I am trying to find a way to "fill in" a funtion.
I have F2=E2+F1, for example. I want the cell next to it, G2, to be
=E2+G1. In other words, I want Row 2 to be the addition of E2 to each
cell in Row 1. however, when i "fill in", G2 becomes =F2+G1.
How do I make E2 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968

Adding a constant to a formula. Problems w/filling in
 

Just fix the column ref ("E") in "E2" with a dollar sign ($)
Amend the formula in F2 to: =$E2+F1
Then copy F2 to G2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zuri125" wrote in
message ...

I am trying to find a way to "fill in" a funtion.
I have F2=E2+F1, for example. I want the cell next to it, G2, to be
=E2+G1. In other words, I want Row 2 to be the addition of E2 to each
cell in Row 1. however, when i "fill in", G2 becomes =F2+G1.
How do I make E2 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile:
http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968

Adding a constant to a formula. Problems w/filling in
 

Hi!

Use this as the formula in F2:

=$E2+F1

Then just copy across the row as needed.

The $ keeps the column from changing.

Biff

"zuri125" wrote in
message ...

I am trying to find a way to "fill in" a funtion.
I have F2=E2+F1, for example. I want the cell next to it, G2, to be
=E2+G1. In other words, I want Row 2 to be the addition of E2 to each
cell in Row 1. however, when i "fill in", G2 becomes =F2+G1.
How do I make E2 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile:
http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968

Adding a constant to a formula. Problems w/filling in
 

ok, thanks you for that.
But, the $ only works for rows.

I have F2=E2+F1, for example. I want the cell below it, F3, to be
=E3+F1. In other words, I want Column F to be the addition of F1 to
each cell in Column E. however, when i "fill in", F3 becomes =E3+F2.
How do I make F1 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968

Adding a constant to a formula. Problems w/filling in
 

Use this:

=$E2+F$1

Biff

"zuri125" wrote in
message ...

ok, thanks you for that.
But, the $ only works for rows.

I have F2=E2+F1, for example. I want the cell below it, F3, to be
=E3+F1. In other words, I want Column F to be the addition of F1 to
each cell in Column E. however, when i "fill in", F3 becomes =E3+F2.
How do I make F1 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile:
http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968