## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# 7.3. Mastering Multiplication

## Problem

You already know how to perform normal multiplication using the * operator, but need to perform other multiplication operations.

## Solution

Use Excel's various multiplication functions , which are summarized in Table 7-3.

Table 7-3. Common multiplication functions

Function

Syntax

Description

`PRODUCT`

`=PRODUCT(` `n1` `,` `n2` `,` `n3` `,` ...`)`

Returns the product of all given numbers, which may include cell ranges and explicit numbers.

`LCM`

`=LCM(` `n1` `,` `n2` `,` `n3` `,` ...`)`

Returns the least common multiple of the given integer numbers.

`SUMPRODUCT`

`=SUMPRODUCT(` `array1` `,` `array2` `,`...`)`

Adds the products of corresponding values in given cell ranges (called arrays). The ranges must have the same number of elements.

## Discussion

Excel provides a handy utility to multiply a range of numbers by some value in one fell swoop. For example, say you have a range of data like that shown in Figure 7-1, whch you'd like to scale by a factor of 1,000.

Follow these steps to quickly scale the data in the range B3:B19 by 1,000. Type the scale factor, `1000` in this case, in a cell (in Figure 7-1, I put it in cell B1). Select the cell containing the scale factor. Select Edit → Copy from the main menu bar. Now, with the mouse, select the range containing the data to be scaled (range B3:B19 in this example). From the main menu bar, select Edit → ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required