Chip Sengravy

I'm trying to cobble up something to work out my expenses...


in K3, I enter my rate per mile...say £0.10...this is just one field to act as a multiplier for the whole sheet.



then in c12 I enter the miles I have done, say 43 miles. in d12 I put '=c12*k3'

The box d12 gets added up along with other suff to form an amount for the whole day...

this all works peachy, but whenever I drag the formula, or copy into the rows below for the next days claims, it automatically changes the k3 to k4

there isnt anything entered into K4


where am I going wrong ?


thanks in advance

Rage!

Enter K3 in your equation as $K$3.... this will anchor it!

brumdaisy

Did nobody tell you its the day of rest? now go sit in the garden with a cold beer you'll feel much better

Chip Sengravy

**** me, that was quick!

Cheers!

Chip Sengravy

I feel better already

ChungsterSTI

and for future reference, use the F4 key when editing the formula inside the formula box and it will scroll thru the locking/anchoring options.

Having a $ before both Row(letter) and Column(number) means u lock single cell.

Have a $ before the Row means u lock that row (good for dragging downwards)

Same for Column (dragging sideways)

Row and Column for dragging down and across.

Flatcapdriver

HIJACK!

Chip, rather than start a new thread that will be dispensed to the forum where I can't understand what's being said I'm nicking your thread...

I want to create tick boxes in a WORD document and whilst I can create one using the 'insert table' function I cannot copy and paste it? I want to create a series of tickboxes for a Likert Scale that I'm doing.

Any takers?

Chip Sengravy

No way, hose' !

get your own thread


can you not just add a text box with a tick symbol in it next to each line?

richardg

..."insert", "symbols" change to wingdings, then paste one of these three - o ü þ - obviously unlikely to show properly on here, but try copying and pasting those three symbols into a word doc and delete the two you don't want