is there a way i can do it with one formula and not have to type in c1-d1,
c2-d2, etcc...i have about 100 rows

"Dave F" wrote:

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...