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?

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!

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 ]