Open the document you wish to calculate multiplication. Now press and hold left mouse button and drag, sales of this month of all items are calculated.ġ. Click cell G8 for last month sales of laptops.Ħ. Now type “-” sign to perform subtraction.ĥ.
Now press “equals” sign and click cell F8 to select total sales.Ĥ. Click in the cell H8 to perform subtraction between last and total sales for laptops to find this month’s sales.ģ. It is required to find this month’s sales. The data for last month and total sales are known. This example here shows the total sales of mouse, laptops, LCDs, and keyboards. Open the document you wish to calculate subtraction. Now press and hold left mouse button and drag, the total sales of all items are calculated.ġ. Now click the cell and bring your cursor to the bottom right of the handle, notice the cursor changes to plus sign.Ĩ. You got your total sales for shoes for current and previous month.ħ. Click cell G8 for this month sales of shoes.Ħ. Now press “equals” sign and click cell F8 to select last month sales of shoes.Ĥ.
Click in the cell H8 to perform addition between last and this month’s sales for shoes and find the gross sales.ģ. This example here shows the sales done in previous and this month and now it is required to find out the total sales.Ģ. Open the document you wish to calculate addition. Though there are many complicated functions performed by this software but here you will know how to use formula in excel to perform basic functions in detailed steps. But if you are the type of person who wants to calculate basic formulas in excel but wondering how to use formula in excel ? This is the article for you. Excel is the most widely used and popular software for calculating basic tasks and also used for business related complicated functions.
0 kommentar(er)
