Simple formula question (well difficult for me)

[SUZYBROON]

I want to create a formula which will calculate an hourly rate.

=c1*27.71

the column 'c 'shall stay the same but row number 1 should then go to 2, then 3, then 4 etc.

I then want to copy and paste this down the column.

Any help greatly appreciated

 

[VoG]

Perhaps you mean this

=$c1*27.71

 

[MrKowz]

Welcome to the forums!

You can lock Column and Row references by putting a "$" in front of them.

So to lock the formula so that column C does not change, no matter where the formula is placed, try:

=$C1*27.71

 

[SUZYBROON]

Wow, what quick replies! Thanks guys!

Woohoo yippee it works!

I'm a very happy lady now!! Me thinks this isn't the last time I visit this forum!!!!!

Suzy

 

[MrKowz]

Wow, what quick replies! Thanks guys!

Woohoo yippee it works!

I'm a very happy lady now!! Me thinks this isn't the last time I visit this forum!!!!!

Suzy

Glad we were able to assist. Thank you for the feedback.

 

[328mike]

Also, you can press F4 with a highlighted part of your equation and it will auto lock the row and column. You can keep pressing it to lock both one or the other or none. Nifty trick to save time.