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