Xbox Mod Chip | Property Search | Pest Control | Loans | Mortgages
Excel Question [Archive] - PCMech Forums

PDA

View Full Version : Excel Question


Force Flow
05-31-2003, 01:36 PM
I'm kind of new to using excel for using formulas, so this'll probably be an easy question for you veterans.

How do you multiply columns? For example, how do you multiply cell B2 by C2 and get the answer in D2? And, can you do this for the whole column (50 entries)?

bonzai
05-31-2003, 03:06 PM
have cell D2 selected. enter in the following: '=b2*c2'

If you want the result in column D to reflect the multiplication of column B times column C in their respective rows, just copy cell D2 and paste it all the way down.

Force Flow
05-31-2003, 03:35 PM
Great! It worked! Thanks, Bonzai :)