HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS !
"FSt1" wrote:
hi
use absolute references ie
not H7
use $H$7
or
=(A1*$H$7)
regards
FSt1
"FROGGYDOLLY" wrote:
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 CELL -
B1*H7, C1*H7, D1*H7, E1*H7, ......
|