How to Multiply in Microsoft Excel.pptx

Technology

1. Multiplying Using Microsoft Excel Second Form Iinformation Technology

2. 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. For example, if you type "=2*6" into a cell and press Enter on the keyboard, you should see the cell display "12."

3. How to multiply two numbers in Excel You can also multiply two different cells together. 1. In a cell, type "=" 2. Click in the cell that contains the first number you want to multiply. 3. Type "*". 4. Click the second cell you want to multiply. 5 . Press Enter.

4. How to multiply cells and numbers using the PRODUCT formula

5. How to multiply two numbers in Excel You aren't limited to multiplying just two cells — you can multiply up to 255 values at once using the PRODUCT formula. Using this formula, you can multiply individual cells and numbers by separating them with commas and multiply a series of cells with a colon. Remember that the order of these cells and numbers is irrelevant in multiplication.

6. Product Formula: Multiplying Cell Ranges If you want to multiply the contents of cells A1 to A7; you would need to use the following formula: =PRODUCT(A1:A7)

7. Product Formula: Multiplying a Series of Cells Explanation: =A1*A2*A3*A4*A5*A6*A7*B1*B2*B3*B4*C1*8 produces the exact same result. If you would like to multiply many columns together, you will need to use the following format: