How to Multiply in Excel 2007
In an earlier section, you saw how to add two numbers. Now, we'll practice how to multiply two, even three numbers. You use the asterisk symbol between two cell references:
= A4 * B5
If you need to multiply more than two numbers, you don't have to do this:
= A4 * A5 * A6 * A7 * A8
You can use the colon (:) notation to shorten the formula. With addition, you used the word SUM, and placed your formula between round brackets:
= SUM(A4:A8)
With multiplication, you can use the word PRODUCT instead. Like this:
= PRODUCT(A4:A8)
The only thing that has changed here is the name of the inbuilt function: PRODUCT instead of SUM. But Excel 2007 will see the word Product and multiply whatever is between the round brackets.
You can use PRODUCT in the same way you did for SUM. For example, if you wanted to add up values in cells A4 to A8, and cells B4 and B5, you'd do it like this:
= PRODUCT(A4:A8, B4, B5)
To give you some practice, try these exercises. Click here to open the exercise.
