You can watch the video or just read the text below. Both will give you the same information.
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.