Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Multiply Numbers in Excel 2013

In this video you’ll learn how to multiply numbers in Excel.

If you only want to multiply a couple of numbers, simply enter the numbers directly into a new cell after an equals sign and using the asterisk as the sign for multiplication: =2*2.

If you want to write a formula that you can copy and apply to other sets of numbers, the easiest way to do so is by noting the cell references of the numbers you want to add and applying this simple formula: “=A1*A2”.
This can easily be extended to add more than two numbers, for instance
“=A1*A2*A3”

You can also use your mouse to select cells that contain numbers that you want to multiply.
If you have a large amount of numbers to multiply, the quickest way is to type a range of cells separated with a colon (:) to multiply all the numbers contained in the range you specified.