Column Forumulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GuitarFingers - 24 May 2006 07:29 GMT

I'm sure this is simple, but i suck with excel. Okay, I want to
mulitply column A by column B and paste the product into column C. For
example, A2 x B2 = C2, but for say, 100 rows without having to do it by
hand.

Signature

GuitarFingers

Reply to this Message

Bob Phillips - 24 May 2006 08:05 GMT

Select the 100 cells in C, starting at C2

In the formula bar, enter =A2*B2

Use Ctrl-Enter to enter the formula (not just enter)

Signature

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

> I'm sure this is simple, but i suck with excel. Okay, I want to
> mulitply column A by column B and paste the product into column C. For
> example, A2 x B2 = C2, but for say, 100 rows without having to do it by
> hand.

Reply to this Message