software

I am trying to find a way to quot;fill inquot; 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 quot;fill inquot;, G2 becomes =F2 G1.
How do I make E2 a constant in the formula?--
zuri125
------------------------------------------------------------------------
zuri125's Profile: www.excelforum.com/member.php...oamp;userid=31131
View this thread: www.excelforum.com/showthread...hreadid=507968Just fix the column ref (quot;Equot;) in quot;E2quot; with a dollar sign ($)
Amend the formula in F2 to: =$E2 F1
Then copy F2 to G2
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;zuri125quot; gt; wrote in
message ...
gt;
gt; I am trying to find a way to quot;fill inquot; a funtion.
gt; I have F2=E2 F1, for example. I want the cell next to it, G2, to be
gt; =E2 G1. In other words, I want Row 2 to be the addition of E2 to each
gt; cell in Row 1. however, when i quot;fill inquot;, G2 becomes =F2 G1.
gt; How do I make E2 a constant in the formula?
gt;
gt;
gt; --
gt; zuri125
gt; ------------------------------------------------------------------------
gt; zuri125's Profile:
www.excelforum.com/member.php...oamp;userid=31131
gt; View this thread: www.excelforum.com/showthread...hreadid=507968
gt;
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

quot;zuri125quot; gt; wrote in
message ...
gt;
gt; I am trying to find a way to quot;fill inquot; a funtion.
gt; I have F2=E2 F1, for example. I want the cell next to it, G2, to be
gt; =E2 G1. In other words, I want Row 2 to be the addition of E2 to each
gt; cell in Row 1. however, when i quot;fill inquot;, G2 becomes =F2 G1.
gt; How do I make E2 a constant in the formula?
gt;
gt;
gt; --
gt; zuri125
gt; ------------------------------------------------------------------------
gt; zuri125's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31131
gt; View this thread: www.excelforum.com/showthread...hreadid=507968
gt;

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 quot;fill inquot;, F3 becomes =E3 F2.
How do I make F1 a constant in the formula?--
zuri125
------------------------------------------------------------------------
zuri125's Profile: www.excelforum.com/member.php...oamp;userid=31131
View this thread: www.excelforum.com/showthread...hreadid=507968Use this:

=$E2 F$1

Biff

quot;zuri125quot; gt; wrote in
message ...
gt;
gt; ok, thanks you for that.
gt; But, the $ only works for rows.
gt;
gt; I have F2=E2 F1, for example. I want the cell below it, F3, to be
gt; =E3 F1. In other words, I want Column F to be the addition of F1 to
gt; each cell in Column E. however, when i quot;fill inquot;, F3 becomes =E3 F2.
gt; How do I make F1 a constant in the formula?
gt;
gt;
gt; --
gt; zuri125
gt; ------------------------------------------------------------------------
gt; zuri125's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31131
gt; View this thread: www.excelforum.com/showthread...hreadid=507968
gt;