![]() |
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 <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 |
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