Inputting numerical data into your spreadsheets often requires you to do some math. Fortunately, you can make Microsoft Excel do the math for you. To multiply numbers in Excel, you need to familiarize yourself with the multiplication (*) and equal (=) sign.

**Here is how to multiply numbers in Excel:****Multiplying Numbers Inside Cells**

In this example, we are going to try to find the product for

**4 and 5**.

**Step 1:**

Click an empty cell.

**Step 2:**

Enter the formula into the cell. For example if you want to multiply

**20 and 5**, enter the following formula:

**=20*5**.

**Step 3:**

Press

**Enter**to find the solution (the solution is

**100**).

**Multiplying Different Cells**

What if you want to multiply a cell by another? In this example, we are going to try multiply cell

**A1**(8) by Cell

**B1**(4).

**Step 1:**

Click an empty cell.

**Step 2:**

Enter the formula into the cell. Since you are trying to find the product for cells

**A1**and

**B1**, enter the following formula:

**=A1*B1**.

**Step 3:**

Press Enter to find the solution.

**Multiplying Many Cells at Once**

What if you want to multiply numerous cells the same time? In this example, we are going to find the product for cells

**A1, B1, C1, and, D1**(8*7*6*5).

**Step 1:**

Click an empty cell.

**Step 2:**

Enter the formula into the cell. Since you are trying to find the product for cells

**A1, B1, C1, and D1,**enter the following formula:

**=PRODUCT(A1:D1)**. The colon indicates you are multiplying from

**A1 to D1**.

**Step 3:**

Press Enter to find the solution.