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

[zuri125]

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?

 

[Max]

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

 

[Biff]

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]

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 b
=E3+F1. In other words, I want Column F to be the addition of F1 t
each cell in Column E. however, when i "fill in", F3 becomes =E3+F2.
How do I make F1 a constant in the formula

 

[Biff]

Use this:

=$E2+F$1

Biff