View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How can I set a column equate a product of two columns?

=A1*B1

or

=PRODUCT(A1:B1)

then copy down


--

Regards,

Peo Sjoblom




"z" wrote in message
...
How can I set a column equate a product of two columns?
For example, I need put the product of column A and B to column C, So that
when I input numbers to A and B, I can get their product in column C (
C=A*B)
thanks!