How to Multiply in Excel

Monday, 17 June 2013
How to Multiply in Excel
In an earlier section, you saw how to multiply two 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:

View Docs

No comments:

Post a Comment