Static cell in a formula

[Geelum]

I am copying the following formula down a column and need the f2 to remain constant instead of canging to f3,f4 ....

=IF (OR (C10=0),"",INT (YEARFRAC (C10,F2)))

Can anyone help?

 

[Scott T]

Make it absolute

=IF (OR (C10=0),"",INT (YEARFRAC (C10,$F$2)))

 

[Geelum]

Great thanks. Im a complete novice as you can tell

 

[Scott T]

Glad to help.

To explain it more in depth
$F$2 is an absolute reference neither the column or row number will change when copied.
$F2 is a mixed reference the column is locked and will not change but the row can change.
F$2 is a mixed reference where the row is locked and will not change but the column can change.