O'Reilly logo

Excel Scientific and Engineering Cookbook by David M Bourg

Stay ahead with the world's most comprehensive technology and business learning platform.

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

Start Free Trial

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.

Data to be scaled

Figure 7-1. Data to be scaled

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.

Start Free Trial

No credit card required