View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK
 
Posts: n/a
Default 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