Microsoft excel tutorials for beginners_Part-05

Multiplication and Share on MS Excel

In the previous discussion, we have learned to add and subtract in MS Excel. Let us now know how to multiply and share in MS Excel. The formula is to add and subtract like multiplication and division. So now we will know about the multiplication and sharing formula in MS Excel.

Rules of Quality

First, we will discuss how to calculate the number of two numbers. Suppose two numbers will be 5 and 6, so first select one of the cells. Enter formula bar = 5 * 6 then press Enter, then you will get the product in the selected cell. If you want to multiply the multiplication of more than two, such as 5, 6, 30, 900. Then select the cell which you want to find out the product. Then type in the formula bar = 5 * 6 * 30 * 900 then press Enter then the product will be available in the selected cell.

Again, if two numbers like 5 and 6 are in two different cells B2 and C2, and want to find out the difference in E2 cells. In that case, select E2 cell, then type in formula bar = B2 * C2 and then press Enter then the product will be in E2 cell.

If more than two numbers like 5, 6, 30, 900 are respectively B2, B3, B4, B4, and want to find out their attributes in the C5 cell. In that case, select the C5 cell, then type in Formula bar = B2 * B3 * B4 * B5 and press Enter. Then the quality of the C6 cell will come in.

Using Product Function:

While working on Excel Sheet, it may also be possible to find out the number of factors in 40 numbers. In that case, select the cell to extract the quality of the formula bar, showing the quality of 40 cells, the time consuming and the problem of the problem, it may be wrong and maybe. In that case, we can use functions to find more number factors. The function is PRODUCT

Suppose five numbers, such as 20, 30, 40, 50, 60, respectively, are in B2, B3, B4, B5, B6 cells, and their quality will be found in D4 cells. In that case, select D4 cell, then enter Formula Bar = PRODUCT (B2: B6) then press Enter. Then the product will come in the D4 cells. In this way, you can find results in any cell using a formula.

One thing has already been said, the use of cell addresses in the formula is wrong, if the number is wrong, then changing the number and clicking on any cell, the results will be automatically corrected in the result cell.

Share the rules

Now we will know how to share in MS Excel. Suppose we will draw two numbers of a number, which is a number 10 which we will divide by 2. For this, first, select a cell, then type in Formula bar = 10/2 then press Inter. The selected cell will come in the segment. If two numbers 10 and 5 are in two separate cells B2 and C2 cells and want to extract their divisible E2 cells. In that case, select E2 cell, then enter in formula bar = B2 / C2 then press Inter. Then the E2 cell will have its fragment. Thus, you can find out the number of different cell numbers in any cell.