Microsoft Office Tutorials and References
In Depth Information
Multiplying Multiple Numbers
In a worksheet, either the POWER function or the carat can be used. For
example, in a cell you can enter =POWER(4,3), or =4^3. The result is the same
either way. The carat is inserted by holding Shift and pressing the number 6
key on the keyboard.
Multiplying Multiple Numbers
The PRODUCT function is useful for multiplying up to 255 numbers at once.
The syntax follows:
=PRODUCT (number1, number2,…)
Cell references can be included in the argument list, as well as actual
numbers, and, of course, they can be mixed. Therefore, all these variations work:
=PRODUCT(A2, B15, C20)
=PRODUCT(5, 8, 22)
=PRODUCT(A10, 5, B9)
In fact, you can use arrays of numbers as the arguments. In this case, the
notation looks like this:
=PRODUCT(B85:B88,C85:C88, D86:D88)
Here’s how to use the PRODUCT function:
1. Enter some values on a worksheet.
You can include many values, going down columns or across in rows.
2. Position the pointer in the cell where you want the results displayed.
3. Enter =PRODUCT( to begin the function.
4. Click a cell that has a number.
Alternatively, you can hold down the left mouse button and drag the
pointer over a range of cells with numbers.
5. Enter a comma ( ,).
6. Repeat Steps 4 and 5 up to 255 times.
7. Enter a ), and press Enter.
The result you see is calculated by multiplying all the numbers you selected.
Your fingers would probably hurt if you had done this on a calculator.
Search JabSto ::




Custom Search