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.
Just edit the formula and add the equals sign to the front.
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”.
