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.

Use a combination of the special pasting options along with a product function to multiply a column by a specific percentage.

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