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”.
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.
