Are you trying to get used to how Microsoft Excel works and aren’t sure how to manipulate common cells with standard arithmetic? We’ve already shown you how you can subtract and divide in Microsoft Excel, but now we’re going to show you how you can multiple in Excel. It’s actually really easy, and anyone can learn how to do this. We guarantee that, after reading this article, you’ll be a multiplication wizard in Microsoft Excel!
The Multiplier Formula
As you have probably already discovered, there’s no actual command to multiply cells and values in Microsoft Excel. Everything operates on formulas, which are essentially easy programming formulas that you have to type out yourself.
To get started, type in a value in Cell A2. For the purpose of this article, we’re going to use the value 11. Next, type in a value in Cell B2. We’re going to use 10.
Now that we have our values in Cell A2 and B2, we can create our multiplication formula. In Cell C2, type in the “=” character. The equal sign is a character that we have to have before we can define the formula. Immediately after the character (no spaces) type in A2, the multiplier character “*” and then B2. Press Enter. Your formula should look like this: =A2*B2
If that is indeed your formula, in Cell C2 you should get the multiplied value of A2 and B2. If you don’t want to use so many cells like this, you can multiple values themselves to. For example, in Cell A2, you could simply do =11*10 and that would give you the value 110 in Cell A2.
And that’s all there is to multiplication in Microsoft Excel. Remember that you can use the multiplier alongside other arithmetic operators like subtraction, addition, and division as well. Just keep in mind the order of operations, otherwise you might run into some confusing numbers!