Greetings all. I have column A "Product", column B "Quantity", and I want to
add column C "Total Cost", all with data starting at row 5. I want to choose
cell C1 and enter in a dollar amount. Then I want to format C5:C10000 to be
equal to the value in column B multiplied by the dollar amount in C1. I
tried to do the formula for C5=B5*C1 then drag it down. What happens is that
when I drag it down to row 6 the formula becomes C6=B6*C2 and so forth. I
need to be able to make C1 stay constant for the entire column. Thank you in
advance.