HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS SO MUCH.
MICHELLE
"T. Valko" wrote:
Try it like this:
=A1*H$7
The $ "locks" the row number.
Likewise, if you were copying across a row =A1*$H7, "locks" the column
letter.
$H$7 "locks" both column and row.
--
Biff
Microsoft Excel MVP
"FROGGYDOLLY" wrote in message
...
I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.
HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE
COLUMN THAT CELL STAYS THE SAME ?
EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST
CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT
ELL -
B1*H7, C1*H7, D1*H7, E1*H7, ......
|