ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   product function (https://www.excelbanter.com/excel-worksheet-functions/25613-product-function.html)

spiderman

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



Max

Put in C1: =A1*B1
Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"spiderman" 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





Bernard Liengme

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" 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






All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com