Format Column with Same Function
 

Hey guys.

I'm trying to format all the cells in column G with the following function:
=E2-F2

How would I format the column so that when data is entered into E2 & F2, G2
would automatically update with the value?

I have tried
=$E2-$F2
and
=E$2-F$2

Both don't work. Any help would be greatly appreciated.
------------------------
Brett Patterson
UMBC EHS Management Major

Maybe just ..

Put in G2: =E2-F2
Copy G2 down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brett Patterson" wrote in
message ...
Hey guys.

I'm trying to format all the cells in column G with the following
function:
=E2-F2

How would I format the column so that when data is entered into E2 & F2,
G2
would automatically update with the value?

I have tried
=$E2-$F2
and
=E$2-F$2

Both don't work. Any help would be greatly appreciated.
------------------------
Brett Patterson
UMBC EHS Management Major

Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

~Brett

"Max" wrote:

Maybe just ..

Put in G2: =E2-F2
Copy G2 down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brett Patterson" wrote in
message ...
Hey guys.

I'm trying to format all the cells in column G with the following
function:
=E2-F2

How would I format the column so that when data is entered into E2 & F2,
G2
would automatically update with the value?

I have tried
=$E2-$F2
and
=E$2-F$2

Both don't work. Any help would be greatly appreciated.
------------------------
Brett Patterson
UMBC EHS Management Major

"Brett Patterson" wrote:
Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

But that's exactly what you should get when you copy down the formula from
G2 ??

In G2: =E2-F2
copied down, you'll get:
In G3: =E3-F3
In G4: =E4-F4
and so on

when you copy down, what are you getting in G3, G4 ?

perhaps calc mode is inadvertently set to "Manual"?
Press F9, does it compute properly now in G3, G4, etc ?

To check / change the calc mode:
Click Tools Options Calc tab
Ensure "Automatic" is checked OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

That's great, you were right. But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00" and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

"Max" wrote:

"Brett Patterson" wrote:
Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

But that's exactly what you should get when you copy down the formula from
G2 ??

In G2: =E2-F2
copied down, you'll get:
In G3: =E3-F3
In G4: =E4-F4
and so on

when you copy down, what are you getting in G3, G4 ?

perhaps calc mode is inadvertently set to "Manual"?
Press F9, does it compute properly now in G3, G4, etc ?

To check / change the calc mode:
Click Tools Options Calc tab
Ensure "Automatic" is checked OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Brett Patterson"

That's great, you were right.

You're welcome !

But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00"
and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

sorry, I'm not sure on this new Q of yours
do hang around awhile for insights from others
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Brett

"Automate" usually means the use of VBA code.

Do you want to go this route?

David McRitchie has an InsertRow macro which will add a formula into an
inserted row.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Ron de Bruin has several macros for copying data.

http://www.rondebruin.nl/copy1.htm


Gord Dibben Excel MVP

On Wed, 5 Jan 2005 12:02:34 +0800, "Max" wrote:

"Brett Patterson"

That's great, you were right.

You're welcome !

But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00"
and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

sorry, I'm not sure on this new Q of yours
do hang around awhile for insights from others