You already know how to perform normal multiplication using the * operator, but need to perform other multiplication operations.
Use Excel's various multiplication functions , which are summarized in Table 73.
Table 73. Common multiplication functions
Function 
Syntax 
Description 



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


Returns the least common multiple of the given integer numbers. 


Adds the products of corresponding values in given cell ranges (called arrays). The ranges must have the same number of elements. 
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 71, whch you'd like to scale by a factor of 1,000.
Figure 71. 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 71, 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 → ...
No credit card required