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.

Open the Microsoft Excel 2010 spreadsheet where you need to multiply a number by a power in a formula. Click on the cell that contains your formula, then click on the formula bar running above the ...