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

In cell C1 (Or whatever cell is the first data cell if you have column
headers etc) enter the following:-

=A1*B1

or if in cell C2 then:-

=A2*B2

Copy formula to bottom

Regards,

OssieMac

"z" wrote:

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!