Site icon Sheet Natives

How to Use MULTIPLY in Google Sheets in 2020?

MULTIPLYReturns the product of two numbers. Equivalent to the `*` operator.

Sample Usage

MULTIPLY(A2,B2)

MULTIPLY(2,3)

Syntax

MULTIPLY(factor1, factor2)

factor1 – The first multiplicand.

factor2 – The second multiplicand.

Notes

Unlike PRODUCT, MULTIPLY only supports the multiplication of two scalar values and takes neither ranges nor more than two arguments.

See Also

SUM: Returns the sum of a series of numbers and/or cells.

QUOTIENT: Returns one number divided by another, without the remainder.

PRODUCT: Returns the result of multiplying a series of numbers together.

MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.

DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.

ADD: Returns the sum of two numbers. Equivalent to the `+` operator.

Examples

Exit mobile version