The formula below multiplies numbers in a cell. Multiplication Formula Using the PRODUCT Function Place the cursor in cell E2 Type PRODUCT Point the cursor to cell A2 Cell containing number 8 Press the SHIFT key. Enter cell references with pointing.
Then in the Arguments input section select the Lookup_col Lookup_value Array 1 and Array 2 from the original table as you need.
The symbol is used to multiply values. 1 First open an Excel spreadsheet and then double-click on cell A1 to type your function. Before Excel 2007 seven is the maximum number in one formula after Excel 2007 you can use up to 64 IF functions in one formula. How to multiply two numbers in Excel The easiest way to do this is by multiplying numbers in a single cell using a simple formula.