Multiplies two numbers together and returns the result. 2 * 42 * 4 returns 8.

This operator also works with arrays. { 1, 2 } * 6{ 1; 2 } * 6 returns the array { 6, 12 }{ 6; 12 } (equivalent to { 1 * 6, 2 * 6 }{ 1 * 6; 2 * 6 }) and { 1, 2 } * { 6, 7 }{ 1; 2 } * { 6; 7 } returns the array { 6, 14 }{ 6; 14 } (equivalent to { 1 * 6, 2 * 7 }{ 1 * 6; 2 * 7 }).

Multiplying together many values

The PRODUCT function is equivalent to this operator. These formulas both return 24:

However, PRODUCT can be invoked with arrays with an arbitrary number of elements. To multiply all the elements of NumberArray together and return the result, use this formula:

"Logical and"

Spreadsheet users often use * to mean "logical and" (conjunction) when manipulating logical arrays. This operator only multiplies numbers together, so use the "logical and" operator && instead. This formula returns only those elements which are both greater than 5 and are odd numbers:

Refer to the documentation of the && operator for an in-depth example.