Solved Excel 2013 - how to keep a formula consisten

[ChrisPbass]

Hi

I am trying to tie one cell into a formula that is being pasted into multiple rows.
I know you can use $ to keep the cell consistent but it doesn't seem to be working.

So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.

 

[strollin]

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

 

[ChrisPbass]

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

DOH i was doing $c9 and c$9. That works great. Thanks.