Multiplication Operator in excel

in excel, there are two method to find out multiplication of the numbers.  To multiply two or more numbers in Excel, you can use the asterisk symbol (*) or PRODUCT Function.

Method 1 Asterisk symbol (*)


Syntax :
=number1 * number2

Example :
=2 * 3
This formula will return the value 6, which is the multiplication of 2 and 3.


Method 2 PRODUCT Function

Alternatively, you can use the PRODUCT function to multiply a range of cells. The syntax for the PRODUCT function is:

Syntax :
=PRODUCT(number1,[number2],...)

Example :
=PRODUCT(33,10)
This formula will return the value 330, which is the multiplication of 33 and 10.