Column multiplied by single cell
 

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.

Column multiplied by single cell
 

C5:

=B5*$C$1

To toggle between absolute and the different versions of relative: put the cursor on or next to the cell address in the formula
bar and press F4 (repeatedly)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Greg Snidow" wrote in message ...
| 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.

Column multiplied by single cell
 

Make C1 reference row-absolute:
C5=B5*C$1

HTH
--
AP

"Greg Snidow" a écrit dans le message
de news: ...
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.

Column multiplied by single cell
 

use C5=B5*$C$1

then drag it down

In the Excel help there is a page called
"Switch between relative, absolute, and mixed references"
which you should read if you want to understand.
--
Allllen


"Greg Snidow" wrote:

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.

Column multiplied by single cell
 

That worked like a charm. Thank you to all.

"Allllen" wrote:

use C5=B5*$C$1

then drag it down

In the Excel help there is a page called
"Switch between relative, absolute, and mixed references"
which you should read if you want to understand.
--
Allllen


"Greg Snidow" wrote:

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.