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