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.
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:
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
To divide numbers, use the / (forward slash) arithmetic operator. For example, if you type the following formula in a cell:
The cell displays the following result:
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:
Please see the image for a more complex example (use of addition, multiplication and division in a single formula.