product function

How can I make column C as product of columns A and B so that every entry in
C would be a product of entries in A and B in the same row? Thank you

Put in C1: =A1*B1
Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"spiderman" <peter_parker@home.com> wrote in message
news:h5dge.9864$941.1291@trnddc08...
> How can I make column C as product of columns A and B so that every entry
in
> C would be a product of entries in A and B in the same row? Thank you
>
>

As an alternative to the multiplication operator *, you could use the
PRODUCT function - the answer was in your question: in C1 use
=PRODUCT(A1:B1) copy down the column.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"spiderman" <peter_parker@home.com> wrote in message
news:h5dge.9864$941.1291@trnddc08...
> How can I make column C as product of columns A and B so that every entry
> in
> C would be a product of entries in A and B in the same row? Thank you
>
>