You can also multiply cell ranges (ranges of numbers in your data set). To do so, you'll use the PRODUCT function. Here's how: Step 1: Choose where you want your range to begin and end.

3] How to create Formula to Multiply in Excel To create a formula that performs the multiplication of numbers, you should use the asterisk symbol (*), for example, =1200 *3.

A dialog box opens. Click "Multiply" in the Operation section and click "OK." The values in each of the column's cells change to reflect the product.

Using a Caret Open the Microsoft Excel 2010 spreadsheet where you need to multiply a number by a power in a formula.