Excel Formulas

[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

 

[parry]

-----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
.

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

 

[Norman Harker]

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.

 

[Gord Dibben]

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