|
|
#2
10-20-2005, 12:44 AM
|
|||
|
|||
Re: Excel problem
[ QUOTE ]
Ok i need to be able to enter a value into A2 of excel and have the entire column of b multiplied by that variable. How do you do this? [/ QUOTE ] In the formula in column C, use $A$2 instead of A2. The dollar signs denote that the A and the 2 are fixed references. So basically, in C2, you would have "=$A$2*B2". You can fill this down the column as necessary by highlighting a range of cells with the desired formula in the top cell of this range, then hitting ctrl+d. This will have the effect of creating a list of values in column C that are equal to the corresponding value in column B multiplied by the value in A2. 
|
|
#5
10-20-2005, 02:41 AM
|
|||
|
|||
|
Re: Excel problem
[ QUOTE ]
Also instead of typing in the dollar signs everytime -- as a shortcut after you select the cell just push F4, and it will put both dollar signs in. Very helpful when you have to do it a lot. [/ QUOTE ] Nice tip, thanks.
|
|
#6
10-20-2005, 02:47 PM
|
|||
|
|||
|
Re: Excel problem
[ QUOTE ]
[ QUOTE ] Also instead of typing in the dollar signs everytime -- as a shortcut after you select the cell just push F4, and it will put both dollar signs in. Very helpful when you have to do it a lot. [/ QUOTE ] Nice tip, thanks. [/ QUOTE ]
|
|
#7
10-21-2005, 12:22 AM
|
|||
|
|||
|
Re: Excel problem
[ QUOTE ]
[ QUOTE ] [ QUOTE ] Also instead of typing in the dollar signs everytime -- as a shortcut after you select the cell just push F4, and it will put both dollar signs in. Very helpful when you have to do it a lot. [/ QUOTE ] Nice tip, thanks. [/ QUOTE ] [/ QUOTE ]
|
 |
|
|
Linear Mode
