Fill Down not working

[Guest]

After I typed in my formula and tried to fill down the column by selecting Edit->Fill->down
But it doesn't work why?>

 

[Mark W.]

Select the cell containing your formula and cells below it that you want to fill.

 

[Guest]

I have a formula
=if(a2="something",J2,J2)
I am wondering is there a way to keep the second J2 for the rest of the rows when the formula fill down and not change to J3, J4...
Thanks

 

[Steve Hartman]

Use =if(a2="something",J2,$J$2)
This message was edited by Steve Hartman on 2002-03-07 13:10

 

[Mark W.]

=IF(A2="something",J2,J$2)

...will work too.