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" <zuri125.22n1fm_1138944301.6196@excelforum-nospam.com> wrote in
message news:zuri125.22n1fm_1138944301.6196@excelforum-nospam.com...
>
> 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
>

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" <zuri125.22n1fm_1138944301.6196@excelforum-nospam.com> wrote in
message news:zuri125.22n1fm_1138944301.6196@excelforum-nospam.com...
>
> 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
>

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?

Use this:

=$E2+F$1

Biff

"zuri125" <zuri125.22n3im_1138947002.0745@excelforum-nospam.com> wrote in
message news:zuri125.22n3im_1138947002.0745@excelforum-nospam.com...
>
> 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
>