Dragging a formula without changing certain pieces. [closed]

asked 2016-04-19 16:39:03 +0100

JDBComputing gravatar image

updated 2016-04-19 16:55:53 +0100

I have a fixed value in cells C2, C3, C4, C5 containing ebay/Paypal fee structures.

I have a price in cell D9, D10, D11, etc - which does change depending on the thing for sale.

In E9, I have the formula =SUM(C4+(D9*C5)) - adds the value C4 to D9xC5.

I need to greatly extend the size of the spreadsheet - it is a way of figuring out transaction fees.

Unfortunately if I drag E9 to E10, the formula would change to =SUM(C5+(D9*C6)).

I need to keep the C4/C5 references the same, but change the middle D9 reference. I have tried copying and pasting the formula but that didn't work. Is there a way to do this or am I doomed to manually edit 400 lines?

Thanks in advance.

Solved - needed to be C$4.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by JDBComputing
close date 2016-04-19 16:55:19.428233