Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions | |||
Ignoring charachter data with Product function | Excel Worksheet Functions |