Multiplying numbers in Excel isn't always the easiest thing to do, but it can be done. Here's how to do it in four ways, depending on what you need to multiply.

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.

Open the Excel 2010 spreadsheet where you need to multiply a number by a power. Click on an empty cell and type the following formula:=POWER (x,y)Where "x" is the number you want to multiply, and ...

In the cell underneath this (A2), multiply by the appropriate factor, depending on how many times per year you get paid. For example, if you get paid biweekly, you'll multiply by 26.