# Multiplication operator (*)

*****Value2

## Value1 — Number or { Number }

A number to multiply the second number by (the first *factor*).

## Value2 — Number or { Number }

A number to multiply the first number by (the second *factor*).

## Returns — Number or { Number }

The product of the two numbers.

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 field values of the Field1:Field3Field1:Field3 range together and return the result, use this formula:

(The Field1:Field3Field1:Field3 range is a short-hand way
of expressing an array containing *Field1* and *Field3*, as
well as any fields that appear between them, such as *Field2*. If only
*Field2* appears between the other two fields, Field1:Field3Field1:Field3 and { Field1, Field2,
Field3 }{ Field1;
Field2; Field3 } are equivalent.)

## Using * for "logical and"

Spreadsheet users often use * to mean "logical and"
(conjunction) when manipulating logical arrays. This formula returns only
those fields whose values are both greater than 5 **and** are
odd numbers:

Calcapp supports this usage of `*`

, but its standard "logical and"
operator && can also be used:

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

## Examples

Returns only those fields whose values are both greater than 5
**and** are odd numbers.

Returns only those fields whose values are both greater than 5
**and** are odd numbers. This example uses the standard
&& Calcapp operator for
"logical and" (conjunction) instead of the * operator.