Excel Formulas

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I am wanting to subtract years of service & drag the
formula on a worksheet. I have 01/01/2003 (cell H10)in
one cell. The formula to subtract in cell H11 is =YEAR
(H10)-YEAR(F11). This works. I would like to drag the
formula in cell H11 down and it continue to use the H10
cell, not add a cell each time. Does anyone have any
suggestions to fix this? Thank you
 
-----Original Message-----
I am wanting to subtract years of service & drag the
formula on a worksheet. I have 01/01/2003 (cell H10)in
one cell. The formula to subtract in cell H11 is =YEAR
(H10)-YEAR(F11). This works. I would like to drag the
formula in cell H11 down and it continue to use the H10
cell, not add a cell each time. Does anyone have any
suggestions to fix this? Thank you
.
Click to expand...

Hi change H10 to absolute reference.
eg =YEAR($H$10)-YEAR(F11).
 
Hi Kristen!

Use:
=YEAR($H$10)-YEAR(F11).


The $ before the column letter and before the row number fixes the
copied down formula on both the column and the row.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Kristen

Make H10 Absolute Referenced by adding the $ signs.

=YEAR($H$10)-YEAR(F11)

See Help for Absolute and Relative addressing.

Gord Dibben Excel MVP
 
Back
Top