In this tutorial we will learn how to do multiplication in MS Excel. Like addition we can done multiplication in Excel. We can do this with multiplication operator (*). For do multiplication in excel we select the cell where we want to put result of multiplication. After selection of cell we go in formula bar.Write there = reference of cell1 * reference cell2.For example multiply the values of cell A1 and B1 and result store in C1.We select C1 then write in formula bar =A1*B1 then press enter.
Another method is for multiplication in excel we use function named as product. By using the product function it is easy to multiply the data of 10 cells. If we want to multiply the data of 10 cells A1 to A10 and result show in B1 then select B1 and in formula bar we write
Now we want to calculate the bonus of employee on weekly basis. So we need to multiply the total salary of employee with the bonus percentage then we get bonus. So we learn in this article how to do multiplication in Microsoft Excel work sheet.
multiplication in excel example:-
We take our salary sheet add new columns in that sheet named as Bonus Percentage and Bonus. We merge the I1 & j1 with cell which has data salary sheet and merge the I2 & j2 with cell which has data Week 1.
So then we get sheet like this
We can take the bonus by multiply the total salary of week and bonus percentage so we write in cell J4 =H4*I4 then we get the sheet like this:-
Now select the cell J4 and go on home menu and from Clipboard Panel we select Copy or press ctrl + c for the copy.
We select the other cells where we want to apply the formula.