1. Home
  2. Functions
  3. Math
  4. MULTIPLY

MULTIPLY function

Returns the product of two numbers, like the * operator.

Syntax

=MULTIPLY(factor1, factor2)

Arguments

ArgumentRequiredDescription
factor1RequiredThe first number
factor2RequiredThe second number

How to use MULTIPLY

MULTIPLY takes 2 required arguments. Type =MULTIPLY( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=MULTIPLY(6, 7)Result 42

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.