Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use multiplication in a formula

How to use multiplication in a formula

Transcript 

In this lesson, we'll look at how to multiply in Excel. To multiply things in Excel, use the asterisk symbol "*" which is over the 8 key. For example, 8 times 8 is entered as = 8 * 8.

Let's take a look.

As with our previous examples, we have a simple worksheet that contains instructions and several highlighted cell references. Following the instructions in the table, let's build the formulas needed using multiplication.

The first example doesn't need cell references and can be input directly:  = 4 * 5

If you forget the equals sign, you'll see the formula displayed instead of the result. Just edit the formula and add the equals sign to the front.

The second example is 13 times F7, so we need to use both a number and a cell reference.

The next example is C9 times H8. Notice that we get a result of "0"since C9 is "0".

The last example is H11 times D6 which yields, as expected, -200. Like subtraction and addition, you might get a VALUE error if any of the cells contain text. Blank values do not cause an error because Excel treats them as "0".

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you for including transcripts of your videos! I happen to be someone who works better from written instructions with pictures/screenshots than from videos, so I really appreciate this.
Sarah
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page