There is no direct multiply formula in Excel but no worries, there are other** multiple ways to multiply in Excel**. We can use Asterisk (*) which is called multiply sign and other 3 powerful methods to multiply in Excel.

**Table of Contents**hide

**Use of Multiply Sign (*, the Asterisk) for Multiplication in Excel**

To explore this method, weâ€™ll use the following dataset which contains some fruitsâ€™ quantity and unit prices. Now weâ€™ll use Asterisk (*) to multiply the quantity and unit price for each item.

For that, I have added a new column named â€˜Total Priceâ€™.

In **Cell E5** type the following formula-

`=C5*D5`

And actually, itâ€™s the alternate to **10*2**, we used cell reference instead.

After hitting the **Enter **button, you will get the output as shown below.

Then just **drag down** the **Fill Handle** icon to copy the formula for the other items.

Now all the itemsâ€™ total price is calculated by using the **Multiply Sign-Asterisk (*)**.

**Alternatives to Multiply Sign for Multiplication in Excel**

Instead of using the Multiply Sign-Asterisk (*), we can multiply numbers easily by using three alternative methods described below.

**1. Applying PRODUCT Function to Multiply in Excel**

Firstly, weâ€™ll apply **the PRODUCT function** to multiply numbers. The **PRODUCT **function is the prime alternative of using **Multiply Sign-Asterisk (*)**. Letâ€™s find out the total price by using the product function.

Write the following formula in **Cell E5**â€“

`=PRODUCT(C5,D5)`

It will multiply the values of **Cell C5** and **D5**, equivalent to **10*2**. If you want to multiply three values of **Cell C5, D5,** and **E5 **then the formula will be **=PRODUCT(C5,D5,E5)**.

Later, hit the **Enter **button to get the result.

You will get the same output as the output of using **Asterisk (*)**.

Again use the **Fill Handle** tool to copy the formula.

Then you will get all the outputs.

**Read More: What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)**

**2. Inserting Excel SUMPRODUCT Function to Multiply**

**The SUMPRODUCT function** is applied to multiply different arrays together and then it returns the sum of products. In the previous methods if we had to find the sum then we would have to use** the SUM function** to **calculate the sum after multiplying**. But the **SUMPRODUCT **function can do that two tasks at a time. Notice the following steps to do it.

In **Cell D11** write the following formula-

`=SUMPRODUCT(C5:C9,D5:D9)`

Press the **Enter **button.

Hereâ€™s the output of the sum-product-

**Read More: Multiplication Formula in Excel (6 Quick Approaches)**

**Similar Readings**

**If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)****How to Round a Multiplication Formula in Excel (5 Easy Methods)****Multiply Two Columns in Excel (5 Easiest Methods)****How to Multiply a Column by a Number in Excel (4 Easy Methods)**

**3. Using Paste Special Tool to Multiply in Excel**

In our last method, weâ€™ll use the **Paste Special** command in Excel to multiply. We can **multiply a range of data by a constant value** using the **Paste Special** command. Suppose, we have to pay **3% VAT** for each item. So to find the amount of VAT for each item weâ€™ll have to multiply the total values by 3%. Now letâ€™s see how to do it using the **Paste Special** command.

To find the VAT I have added a new column.

Firstly, copy the Total Prices in the new column using **copy-paste**.

Now copy the VAT value from **Cell C11**.

Later, select all the data from the new column and **right-click** your mouse.

Then press **Paste Special** from the **context menu**.

After appearing the **Paste Special **dialog box, mark **All **from the **Paste **section and mark **Multiply **from the **Operation **section.

Finally, just press **OK**.

Now have a look that the whole column is multiplied by the value- 3%.

**Read More: How to Multiply One Cell by Multiple Cells in Excel (4 Ways)**

**Download Practice Workbook**

You can download the free Excel template from here and practice on your own.

**Conclusion**

I hope the procedures described above will be good enough to use multiply sign in Excel. Feel free to ask any question in the comment section and please give me feedback.