Excel Multiply Formula Definition with Formula:
Excel multiply formula is used to multiply the values. We can multiply the values using the multiply symbol in excel, i.e., “*”.
Formula: =number1*number2
Another way of multiplication is using the PRODUCT function.
Formula: =PRODUCT(number1, [number2], ….)
Explanation with Example Questions:
After learning the concept of subtraction in excel, Carl becomes more curious about learning both excel multiply formula and the division formula.
After lunch, Brenda takes both kids to the study room and gives them some questions regarding the multiply function in excel.
- How to multiply cells in Excel?
- How to multiply columns in Excel?
- How to multiply more than two columns in Excel?
Coming to the answers:
How to multiply cells in Excel
Carl solves the question with and without the formula. He multiplies the cells E6 and E7 and gets the output in the E14 cell.
Without using the formula:
Formula: =E6*E7
Answer: 704
Using the PRODUCT formula:
Formula: =PRODUCT(E6,E7)
Answer: 704
How to multiply columns in Excel
Carl solves the question with and without the formula. He multiplies column1 and column2 and gets the output in column4(“PRODUCT”).
Without using the formula:
Formula: =E6*F6
Answer: 320
Using the PRODUCT formula:
Formula: =PRODUCT(E6,F6)
Answer: 320
How to multiply more than two columns in Excel
Carl again solves the question with and without the formula. He multiplies column1, column2, and column3 and gets the output in column4(“PRODUCT”).
Without using the formula:
Formula: =E6*F6*G6
Answer: 640
Using the PRODUCT formula:
Formula: =PRODUCT(E6,F6,G6)
Answer: 640
Brenda is pleased with the efforts of Carl and the hard work he is putting in learning the excel concepts that she is teaching. He has come a long way from learning to create a spreadsheet in excel to using multiply function in excel.