Excel Tutorial
Multiplication and Division in Excel
Multiply numbers in a cell
To multiply numbers in a cell, use the * (asterisk) arithmetic operator. For example, if you type the " =70*5 " formula in a cell, the cell displays 350 as result.
Multiply numbers in different cells by using a formula
To do this task, use the asterisk (*) operator or the PRODUCT function. Please look at the formulas in the Formula bar and the results in the selected cells in the images given below:
Multiply all numbers in a range
To multiply all numbers in a range, please PRODUCT function, as shown in the example below
Alternatively, you can also use asterisk (*) operator. In that case, the formula will be
=A1*B1*C1*D1*E1
Divide Numbers
To divide numbers, use the / (forward slash) arithmetic operator. For example, if you type the following formula in a cell:
=20/4
The cell displays the following result:
5
Divide cells in a range
Like dividing numbers in a cell,use the / (forward slash) arithmetic operator to divide cells in a range. For Example to divide the number in cell A1 by number in cell B2, the formula will be:
=A1/B1
Please see the image for a more complex example (use of addition, multiplication and division in a single formula.