How to apply Excel multiplication formula

Source: Internet
Author: User

To apply the Excel multiplication formula, follow these steps:

1. First open Excel, here casually entered two sets of data. As pictured. Now you want to compute the product of these two sets of data.

2. To calculate the data selected in the following figure, first calculate the product of the first set of data. Select this set of data and click on the function button above. As shown in the figure.

3. In the pop-up menu does not need to use the product formula, click on the other function this option.

4. In the page where the function is inserted, you cannot directly find the product function that you want to use. In the Search function blank box, enter the product two words, and then click Go to the button.

5. At this point, in the list of selection functions, a function of the product appears, at the bottom of the list is a description of the product of all the parameters. Select the Click OK button to exit the Insert Function page.

6. Start to compute the product of the first set of data. Use the mouse to select the set of data just selected, then the set of data will be surrounded by dotted lines, and then in the function parameter box will display this set of data, and at the bottom there will be a calculation results, such as figure.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.