Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Multiplication operator (*)

Value1 * 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:

2 * 3 * 42 * 3 * 4
PRODUCT(2, 3, 4)PRODUCT(2; 3; 4)

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:

PRODUCT(Field1:Field3)PRODUCT(Field1:Field3)

(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:

FILTER(Field1:Field3, (Field1:Field3 > 5) * ISODD(Field1:Field3))FILTER(Field1:Field3; (Field1:Field3 > 5) * ISODD(Field1:Field3))

Calcapp supports this usage of *, but its standard "logical and" operator && can also be used:

FILTER(Field1:Field3, (Field1:Field3 > 5) && ISODD(Field1:Field3))FILTER(Field1:Field3; (Field1:Field3 > 5) && ISODD(Field1:Field3))

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

Examples

2 * 42 * 4

Returns 8.

{ 1, 2 } * 6{ 1; 2 } * 6

Returns the array { 6, 12 }{ 6; 12 }, equivalent to { 1 * 6, 2 * 6 }{ 1 * 6; 2 * 6 }.

{ 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 }.

FILTER(Field1:Field3, (Field1:Field3 > 5) * ISODD(Field1:Field3))FILTER(Field1:Field3; (Field1:Field3 > 5) * ISODD(Field1:Field3))

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

FILTER(Field1:Field3, (Field1:Field3 > 5) * ISODD(Field1:Field3))FILTER(Field1:Field3; (Field1:Field3 > 5) * ISODD(Field1:Field3))

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.