PDA

View Full Version : Excel problem

The4Aces
10-20-2005, 12:30 AM
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?
Nomad84
10-20-2005, 12:44 AM
[ 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.
The4Aces
10-20-2005, 12:50 AM
thanks. you the man!
Bradyams
10-20-2005, 01:31 AM
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.
Freakin
10-20-2005, 02:41 AM
[ 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.
dcasper70
10-20-2005, 02:47 PM
[ 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 ]
Nomad84
10-21-2005, 12:22 AM
[ 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 ]