how to multiply two columns
Assuming your data starts in A1, then in C1 enter this formula:
=A1*B1
Select C1 again and double-click the fill handle - this is the small
black square at the bottom right corner of the cursor, and
double-clicking it will cause the formula to be replicated down column
C for as many data items as you have in column B.
Hope this helps.
Pete
|