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.

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.