thanks for the tip
T. Valko wrote:
Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
15-Feb-08
Try it like this
=A1*H$
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
--
Bif
Microsoft Excel MV
Previous Posts In This Thread:
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
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, ......
Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
Try it like this
=A1*H$
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
--
Bif
Microsoft Excel MV
When you enter the formula you can make the reference to H7 abslolute byEither
When you enter the formula you can make the reference to H7 abslolute b
Either typing $H$7 or by typing H7 and pressing the F4 key
Then, when you copy the formula the cell reference doesn't change
The $ before the column letter says don't adjust the column reference and
the $ row number says don't adjust the row reference
Look up Absolute References in Help for a more detailed explanation
--
Kevin Backman
:
hiuse absolute references ienot H7use $H$7or
h
use absolute references i
not H
use $H$
o
=(A1*$H$7
regard
FSt
:
Use the dollar sign to freeze the column ($H7), the row (H$7), or both
Use the dollar sign to freeze the column ($H7), the row (H$7), or both ($H$7
:
=A1*$H$7The dollar sign will "fix" it, ie make the cell ref absoluteBtw, pl
=A1*$H$
The dollar sign will "fix" it, ie make the cell ref absolut
Btw, pl don't use all caps. Hard on the eyes, and considered impolite by many
--
Ma
Singapor
http://savefile.com/projects/23689
xdemechani
---
You say you have a column of 200 cells but then you describe multiplying
You say you have a column of 200 cells but then you describe multiplying cell
across row 1(A1, B1, C1 etc.) by a constant in H
Which is it? A column or a row.
Whatever the case........If a one-time operation enter the constant number in a
unused cell
Select and copy
Select the range to of cells to multiply and edit>paste special>multiply>ok>esc
Gord Dibben MS Excel MV
On Fri, 15 Feb 2008 10:56:03 -0800, FROGGYDOLL
KEVIN,THANKS SO MUCH. I WAS DRAWING AN "ABSOLUTE" BLANK ON HOW DO IT.
KEVIN
THANKS SO MUCH. I WAS DRAWING AN "ABSOLUTE" BLANK ON HOW DO IT. NOW THA
I'VE READ YOUR RESPONSE - I REMEMBER
THANKS
MICHELL
:
RE: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS
:
Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS SO MUCH
MICHELL
:
You're welcome!
You're welcome
--
Biff
Microsoft Excel MVP
Please turn off the caps lock, it looks like you are SHOUTING.
Please turn off the caps lock, it looks like you are SHOUTING.
If you want to multiply a column of cells by a single cell, simply
change the formula to an absolute reference.
i.e. A1*$H$7
When you fill this down/across, it will change to B1*$H$7, C1*$H$7,
etc.
HTH,
JP
On Feb 15, 1:56=A0pm, FROGGYDOLLY
=A0-
Multiplication by constant cell
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorial...32-0ae26adaa533/c-and-the-little-iterato.aspx