How to multiply, subtract, add and divide in Excel

Learn how to multiply using a simple formula and a couple of steps

how to multiply in excel

You can trust PC GuideOur team of experts use a combination of independent consumer research, in-depth testing where appropriate – which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

Last Updated on

Microsoft Excel comes in handy for anything that requires record-keeping and organizing. Inventory, wages, order processing, you name it, Excel is designed to cater to it. However, people sometimes forget about the basic functions in Excel which have the greatest effect.

Excel can do anything from providing a simple spreadsheet to keep figures organized to collating massive company data and displaying that in various forms of cells and charts. This is thanks to the array of formulas Excel supports to make life easier for its users. It’s like anything else, once a user knows what to do, it’s easy.

How to multiply in Excel

How to multiply in Excel

Calculations are a bit part of Excel’s functionality, and it offers services such as subtracting, dividing multiplication, and more. Rather than quickly working out every calculation needed in a spreadsheet, simply follow the steps below to learn how to multiply single and multiple cells all at once in Microsoft Excel:

Click a cell, any cell

How to multiply in Excel

First, click the cell that needs the multiplication result. Then, locate the cells that need to be multiplied which should be written in the column then row order. In the example below, we’ve chosen cells B2 and C2.

To activate a formula, start it off with =. This tells Exel that the following text is a formula for it to follow. The character for multiplication in Excel is *, so by inserting =B2*C2 into the necessary cell we will get the multiplication result as shown below.

A quick heads up, users can also use – for subtraction, + for addition, and/or divide. Users can do multiple sums in one cell, but make sure to incase the original sum in brackets to get the correct result. For example, if we needed to include £3 postage onto each model batch pictured, we would write =(B2*C2)+3. Want to work out postage for each separate model? Insert a new column and replace 3 with the correct cells.

Need to multiply multiple cells?

How to multiply in Excel

Simple, as shown in the example below, click and hold the bottom right corner of the cell when your cursor turns into a cross and drag it over the rest of the columns needing a multiplication formula. Don’t worry about inputting the correct cells, Excel will figure this out and do it automatically. This also applies to addition, subtraction, and division.

Thanks for choosing PC Guide for learning how to multiply in Excel. We’ve got even more Excel guides over on our Office hub, why not visit and bookmark?