Abstract
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".
