Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiply by a constant
I want to multiply a group of cell's by a constant in anouther cell. If I
drag the bottom right corner it changes the referenced cell. Isn't the "$" somehow used in this function? |
#2
|
|||
|
|||
Yes, you can use
=A1*$B$1 where B1 holds the constant another way woul be to copy B1, select the range and do editpaste special and select multiply Regards, Peo Sjoblom "flotowntiger" wrote: I want to multiply a group of cell's by a constant in anouther cell. If I drag the bottom right corner it changes the referenced cell. Isn't the "$" somehow used in this function? |
#3
|
|||
|
|||
If the constant is located in a specific cell, then use $a$1, for example. )
"flotowntiger" wrote: I want to multiply a group of cell's by a constant in anouther cell. If I drag the bottom right corner it changes the referenced cell. Isn't the "$" somehow used in this function? |
#4
|
|||
|
|||
Hi
=A1*$B$1 if B1 is your constant value. see: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "flotowntiger" schrieb im Newsbeitrag ... I want to multiply a group of cell's by a constant in anouther cell. If I drag the bottom right corner it changes the referenced cell. Isn't the "$" somehow used in this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write a trendline constant into a cell? | Charts and Charting in Excel | |||
How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) |