Question: what is the formula for multiplying two columns in excel?
Answer: For example, to multiply values in columns B, C and D, use one of the following formulas: Multiplication operator: =A2*B2*C2. PRODUCT function: =PRODUCT(A2:C2) Array formula (Ctrl + Shift + Enter): =A2:A5*B2:B5*C2:C5.