You can watch the video or just read the text below. Both will give you the same information.

Multiplication Using Excel

Video Source (03:04 mins) | Transcript

**Star symbol**

Multiplication in Excel is done using the * symbol.

Example: Multiply \(2 \times 3\) in Excel.

Answer: Type “=2*3” into the cell but without the quotation marks. Press

**Enter**. You will see the number 6 in that cell. Up in the formula bar you will see =2*3.

**Parentheses**

A number or variable next to a parenthesis means multiplication, but in Excel we need to include the * symbol too.

Example: Multiply \(3(2+5)\) using Excel.

Answer: Type “=3*(2+5)” into the cell. (Do not include the “” marks.) Press

**Enter**. You will see the number 21 in the cell. Up in the formula bar you will see the formula =3*(2+5).

**Referencing Cells**

To multiply the contents of two cells together by referencing the cells, we use the * symbol between the cell names.

Example: Multiply the contents of A1 and A2.

Answer: Type “=A1*A2” into the cell of choice. (Do not include the “” marks.) Press

**Enter**. You will see the multiplication of the contents of these two cells in the new cell.

## Need More Help?

- Study other Math Lessons in the Resource Center.
- Visit the Online Tutoring Resources in the Resource Center.
- Contact your Instructor.
- If you still need help, Schedule a Tutor.